Skip to Content
0
Former Member
Jan 22, 2012 at 06:32 PM

crystal report 2011 percentage calculation(Urgent)

111 Views

All,

I am working on a report which looks like the below.

product>>>>>>> revenue>>>>>>>>> growth percentage

a >>>>>>>>>>> 12 >>>>>> >>>> 48%

b >>>>>>> >>>>>>>13 >>>>>>>> 52%

c >>>>>>>>>>>>> 14 >>>>>>>>>

d>>>>>>>>>>>>>> 16>>>>>>>>>>>>

total >>>>>>> 25 >>>>> 100%

my requirement is to calculate the individual growth percentage of a and b with the total revenue of a and b only.

to be more specific 12 divided by 25 and then 13 divided by 25.

i want these growth percentages in growth percentage column in my report.

I achieved the selective summation of revenue for a and b in the report footer but i am not able to use the total revenue 25 (that i get in the report footer) in the body of the report(detail section) for growth percentage calculation.

I tried using shared variables and global variables but of no use.i am not able to assign the grand total in the footer to a variable in the detail section in order to calculate the growth percentage.

Is there any easy work around to achieve this? need urgent help.

I also tried running totals and stuff but of no use.

Any help would be appreciated.

Reji.

Edited by: reji2011 on Jan 22, 2012 7:32 PM