What is the best way to handle this calculation
I have a report that has a group configured and the group totals a numeric
field. I would like to get the percentage of the total field on each line
item of the detail band. What is the best way to handle this calculation?
Example:
DETAIL
10 8.00 <---this is want I want to calculate for each detail line item
30 23.00
90 69.00
GROUP TOTAL
130
Thanks in advance
field. I would like to get the percentage of the total field on each line
item of the detail band. What is the best way to handle this calculation?
Example:
DETAIL
10 8.00 <---this is want I want to calculate for each detail line item
30 23.00
90 69.00
GROUP TOTAL
130
Thanks in advance
This discussion has been closed.
Comments
The following example should get you on the right track.
http://www.digital-metaphors.com/tips/PercentageOfGroupTotal.zip
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com