I am writing a report using Crystal 7 that requires that each person's individual total number of items be divided by the total number of items that everyone has done for the week.
The total items is in the group footer as a running total, the formula field to calculate (individual items / total items) is in the details section.
The problem is that it's dividing the individual units by the total of the running total up to the point of that record.
I want it to wait until the running total is complete before calculating each person's indivdual percentage on the whole.
How do I do this?
Thanks.
The total items is in the group footer as a running total, the formula field to calculate (individual items / total items) is in the details section.
The problem is that it's dividing the individual units by the total of the running total up to the point of that record.
I want it to wait until the running total is complete before calculating each person's indivdual percentage on the whole.
How do I do this?
Thanks.