|
I have managed to get as far as creating running totals on a quarterly basis for my report in Crystal. What I want to do now is obtain the product of these 4 totals?
For example, I have 1.05, 1.06, 1.07 and 1.08...I want a field that calculates them like so
1.05 * 1.06 * 1.07 * 1.08 = 1.286...
The totals were obtained after grouping the data using the Top N function in Crystal...
Any help would be greatly appreciated, as I'm brand new to Crystal and quite frustrated...
Thanks Nick
|