Post Author: neils
CA Forum: Formula
Hi,
I have built a crosstab in Crystal XI with the following columns:
PROFILED BUDGET (a) EXPENDITURE TO DATE (b) VARIANCE (a-b)
The profiled budget and expenditure to date columns are both running total fields. I want the variance column to show the difference between the budget and expenditure.
o To set the variance field up as a running total, I assume that I would have to specify that I want this formula evaluated after the budget and expenditure fields , however, I can't work out how to do this on a crosstab.
o Moving the crosstab to the report footer has had no impact.
o If I try to create a basic formula using the running totals, I get the error message "A summary has been specified on a non-recurring field" - I can't find an explanation of this error message on the help menu.
any ideas how this can be solved?
cheers