Home RAP
New Blog Posts: Merging Reports - Part 1 and Part 2

How calculate percentage using a value from summary

edited April 2004 in RAP
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

Comments

  • edited April 2004
    Hi Amauri,

    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.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.