I was wondering if someone could help me regarding an issue I have with running totals.
Currently, the running totals feature allows you to select the following:
- [reset] on change of field
- [reset] on change of group
- use a formula
What I would like to do is use the first option and select more than one field. However, the option only allows you to select one field.
My question is, could I write a formula to mirror what the the 'change of field' is doing, but with more than one 'change of' field?
The example belows shows that on the change of 'Name' and 'Account', calculate the total money that has left the account.
Name Acount Money out (my running total)
P.Jones Account XYZ -12,000
A. Michaels Account ABC -23,000
A. Michaels Account 123 -14,000
If I create a 'change of field' for just the 'name' I would get the following:
Name Acount Money out (my running total)
P.Jones Account XYZ -12,000
A. Michaels Account ABC -37,000
A. Michaels Account 123 -37,000
Note: I have incorporated the running total within a cross-tab.
Thank you
Adam
IP Logged
