I have a complex custom formula that calculates my row detail amounts. Please see my attached screenshot.
I need to be able to divide my row detail totals by the report total to get a percent value. (I.E. 837.50/1793.75 and 956.25/1793.75 ). The problem is that I don't know the report total until all of the row details have been added up(i'm using a custom currency variable to add them together because crystal isn't letting me SUM the row detail amounts I assume because its a complex custom formula).
There are many complex formulas and calcuations to get to the row detail values or I would just calculate that in the SQL stored procedure.
Any Thoughts on precalculating the report total prior to display the row details so I can use that to divide them? Thanks in advance.