Divided function is not coming properly

building reports crystal reports
1

Hi Experts,

I have a report like this

A BShop CShop Total
Computer 30 40 70
RAM 20 10 30
Moniotor 100 90 190

SUM     150 	140	290

(Percentage for BShop):(SUM(B)/Sum(Total))*100

When I created a formula for percentage with this (SUM(B)/Total)*100
my report is coming like this

A BShop CShop Total
Computer 30 40 70
RAM 20 10 30
Moniotor 100 90 190

SUM 150 140 290

Percentage :15000
for BShop

I supposed to get this result Percentage for BShop : 51.72%
I didn’t get where went wrong in the formula, Is my formula looks wrong??

Thanks,

Tims_Bo :india: (BOB member since 2008-07-26)

2

Is your formula really (SUM(B)/Total)*100 or is that a typo? To get total percentage, it should be (SUM(B)/SUM(Total))*100.

-Dell

hilfy :us: (BOB member since 2007-04-16)