How calculate percentage using a value from summary
I have a report like this:
FRUITS
--------------------------------------------------------------
Apple 20 28.57%
Banana 10 14.28%
--------------------------------------------------------------
Tot F 30 42.85%
--------------------------------------------------------------
Others
--------------------------------------------------------------
Potato 10 14.28%
beans 30 42.85%
--------------------------------------------------------------
Tot O 40 57.15%
--------------------------------------------------------------
Summary 70
But i dont know how to get summary value to do calculations. Could you help
me??
Thanks
FRUITS
--------------------------------------------------------------
Apple 20 28.57%
Banana 10 14.28%
--------------------------------------------------------------
Tot F 30 42.85%
--------------------------------------------------------------
Others
--------------------------------------------------------------
Potato 10 14.28%
beans 30 42.85%
--------------------------------------------------------------
Tot O 40 57.15%
--------------------------------------------------------------
Summary 70
But i dont know how to get summary value to do calculations. Could you help
me??
Thanks
This discussion has been closed.
Comments
There are two ways to do this. First, you can find your summary value using
a calculated field in your database and access that to calculate the
percentage at the beginning of the report. This method is guarenteed to
work.
Second, you can use a TppVariable with the LookAhead property set to True.
This should keep updating the variable's value updated as the report
generates.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com