Skip to Content
0
Former Member
Sep 16, 2007 at 08:40 PM

running totals

20 Views

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