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.
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.