Crystal Formulas

[rbvcbr]

I am pulling data from timberline, transaction table.

This table has two fields acct_date and amounts.
If I put from and to acct_dates (5/1/09 - 5/31/09) it gives me that criteria amounts (Column1). This is good. Now - Besides this column1 I want to show amount in another column (Column2) "from day one to 5/31/09" amounts (If there is no amounts in above said Column1 in May, it will be zero - but will have in column2 previous costs/amounts.

Somebody said I have to use/write parameters for both two columns, and write formula to put that parameter data on the report. Can I get help please to create parameters and formulas. Thank you.

 

[VKZIMM]

From the Field Explorer window in Crystal, Click on parameter fields and then the New Button. Create you Start date as a value type of date and create and End Date parameter.
For your formulas, Click on Forumula fields and the New button.
Give it a name and the if you use Crystal syntax
If date >= Start date and date <= End Date
Then your amount else 0
Your second forumla would be
if date < End Date
Then your amount else 0

 

[rbvcbr]

Thank you sir.