Search results for query: *

I'm trying to write a report with multiple sort options. It is telling me that the default: "" needs to be a date field. If I put a date field then it tells me the last three lines need to be a number. What is the proper fix? //Output 1st sorting criteria if count({?Sort Conditions})>=1 then...

Crystal 10/Timberline Database I need help with the below (very lengthy) formula. I have an instance where my "01" number may or may not have a committed cost entry. For instance, cost code "01-710" has a commitment on one job, in which I want that amount to show on the report. On another...

NEWBIE - Crystal 10, Timberline 9.2 I have this very basic formula to look up the amount for "Percent Complete". However, this may have more than one value, so I need to pick the value that has the most recent transaction date, but I'm not sure how to word it. if...

Windows XP, Crystal 10, Timberline database. The following formula, in instances where AP costs nor JC costs have occured, is coming back with a 'blank' value vs. a zero. I'm having difficulty writing the formula to return a zero value in instances where an AP cost transaction nor a JC cost...

I've been staring at this too long, and all my formulas are running together.... Any ideas why this formula is not giving me information within the date parameter? (Yes, I know my formula could be condensed). [wink] I'm using 5/31/06 as my cut off date, and it is still giving me entries that...

CR10 - Trying to sum my Contracts by Year and then have a Grand Total in my Report Footer. The following is the formula (hidden) in my details section to accumulate: WhilePrintingRecords; numbervar RCyrtot; numbervar RCgrtot; if not({@YTD Costs Recognized} = 0 and {@YTD Revenue Earned} = 0 and...

V10.0 - I'm trying to create a running total at the end of group (by year of project) to sum the revised contract amount. Using section expert, I've suppressed based on the following formula: {@YTD Costs} = 0 and {@YTD Work Billed} = 0 and {@Over-Billing} = 0 and {@Under-Billing} = 0 I'm...

I'm trying to write a formula (V.10) that says: if {amount} <field> in [x,y,z] and if {accounting date} <field> is between {firstdayofyear} <formula> and {cutoff date} <formula> then {amount} <field> I'm struggling with the second part of the formula that determines if it falls within the...