Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: changing grandtotalcolumn Post Reply Post New Topic
Author Message
rishu2003
Newbie
Newbie


Joined: 09 Feb 2012
Location: India
Online Status: Offline
Posts: 3
Quote rishu2003 Replybullet Topic: changing grandtotalcolumn
     Posted: 27 Feb 2012 at 3:19am
am creating a cross tab

in that am using percentage as summarization fields and because of that my total is also becoming percentage

ex:_



Name---jan----feb------march--total

xyz------10%---20%----30%---- 25%



in total i want the average how can i do that

10+20+30 / 3 = 30 %

if i change the summarization field to avg all values change .. is there any method other method to change the formula in total
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 27 Feb 2012 at 10:59am
10+20+30 / 3 = 30 % do you mean
(10+20+30 )/ 3 = 20 %
if yeas then
how about a formula like
totext(round(sum({table.amount}, {table.name})/sum(table.amount)*100),0/3) +"%"
place it into crosstab as maximum.
IP IP Logged
Printable version Printable version

Forum Jump
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