Joined: 06 Feb 2008
Online Status: Offline
Posts: 3
Topic: Product of Running Totals Posted: 07 Feb 2008 at 3:17pm
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...
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum