General information
Category:
Reports & Report designer
Title:
Using calculations with a summed variable?
I would like to take two totals which are summed by groupings in the report and divid them to come up with the percentage of change.
IE, ((2003 revenue - 2002 revenue)/2002 revenue) * 100. When I do this under the group, it tends to total the percentages for each detail ( 4% + 5% = 9%) instead of recalculating for the summed amounts. What's the best way to get it to do what I want?
Also, what exactly does an * instead of numbers mean in the output?
Thanks,
Sunshine
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only