Crystal Reports Total

Hello all

I am trying to create a running total field in crystal reports where the total does not include the current record.

i.e. the total of all records except the current record.

I need this so that I can take a percentage of the running total so far and then add the result to the running total.

If I use the normal running total field then I create a circular reference i.e. the percentag running total calculation includes the running total and then increments the running total and crystal bombs out.

Any ideas??