Hi,
I have one field "r.tot.amnt" in report layout displaying amount.
At last I want sum of all this amount so in that filed, i have used aggregate function 'total' of r.tot.amnt.
By doing so i am getting total of this amount field proper but i want to calculate some taxes by using this total amount.
So how can i access this total amount field in my report script?
Pls help

Regards,
Nirali

Run the report in debugger mode ,you will see a field aggretaged fields as total..1 or total..0 etc.. you can use them further calculations in report scripts

Example:


after.customer.2:
before.layout:
prod.curr.sub.tot = total..0
fbs.quan.curr.sub.tot = total..1

Just keep in mind - if you change or add total fields the report may re-number them. Then you will need to modify the report script to match the total.. field number.

Just keep in mind - if you change or add total fields the report may re-number them. Then you will need to modify the report script to match the total.. field number.

Hello,

Mark is right, whenn adding or deleting a total-aggregate-field, the total..1 - ...x are renumbered.
So it's not a good idea.
In such cases i built the totals / sums in report script.

Regards