Topic: Sum of percentage on group footer Posted: 02 Aug 2012 at 6:21am
Another issue is --
I have one formula which shows the percentage according to gross we just calculated above. I used this formula to show percentage of gross.
shared numbervar rtTotal;
local numbervar thisTotal;
thisTotal :={dt_VU_GETMSG_SERVICE.TOTALAMOUNT_} % Sum ({dt_VU_GETMSG_SERVICE.TOTALAMOUNT_}, {dt_VU_GETMSG_SERVICE.FSERVICE_NETWORK});
rtTotal :=rtTotal+thisTotal;
and created a new formula for displaying the summary like this
shared numbervar rtTotal;
rtTotal;
but on my report it keep adding the record in the next field.
For Eg:
Details:
Name Percentage
ABC 20%
XYZ 29% ---> Original Value 9%
DFG 31% ---> Original Value 2%
At the end on group footer it shows 31%(last value).
I want to sum all the percentage field on details and show them on group footer.How can I achieve this?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum