This content has been marked as final.
Show 5 replies

1. Re: Calculating Percentage from Total
Ali raza Aug 19, 2018 3:19 PM (in response to Ali raza)I am sorry I clicked on assumed answered by mistake.

2. Re: Calculating Percentage from Total
Deepak Rai Aug 19, 2018 5:25 PM (in response to Ali raza)You can Change That by Marking the Following Reply as Helpful and CORRECT, If it Helps
(SUM({FIXED Corpweek,Ad Id,Clicks:SUM(Clicks)})/ SUM({FIXED Corpweek,Ad Id:SUM(Impressions)}))*100
Thanks
Deepak

3. Re: Calculating Percentage from Total
Ali raza Aug 20, 2018 3:20 PM (in response to Deepak Rai)Hi Deepak
Thanks. This is what i used:
(SUM({FIXED [Corp Week],[Ad Id],[Clicks]:SUM([Clicks])})/ SUM({FIXED [Corp Week],[Ad Id]:SUM([Impressions])}))
It worked for all the other columns but now my subtotal and total columns are messed up:
As you can see the Clickrate by week column, the total shows 2.19% but it should be:
543/19911 * 100 = 2.727%
Also the grand total is wrong. Is there another way to do this correctly? Please advise

4. Re: Calculating Percentage from Total
Deepak Rai Aug 20, 2018 4:44 PM (in response to Ali raza)place your cursor there and change from automatic to sum .
