Straight Table Row Level Calculation....

[israrkhan]

Hello Community,

i have a straight table with one dimension, and two expressions

let say i have country | Budget | Actual | %

in the percent column, i have to calculate the %, and formula is first value of Actual, will be divided by all other values in the down rows..

first row will be empty

120/ 1200 for the second row of %, which is B

170/ 1200 for the third row in % column, which is C

200/1200 for the fourth row in % column... so on

till the end, i have 10 rows fixed...

your help will be highly appreciated,,i am stuck here.. kindly help

Header 1	Header 2	Header 3	Header 4
Country	Budget	Actual	%
A	1000	1200	100 fixed...
B	100	120	120/1200= ?
C	130	170	170/1200 =?
D	150	200	200/1200 = ?
E	80	130	130/1200 = ?
F	90	149	149/ 1200 = ?

[Gysbert_Wassenaar · Accepted solution]

Try sum(Actual)/top(sum(Actual))

[MK_QSL]

SUM(Actual)/Max(TOTAL Aggr(SUM(Actual),Country))

[israrkhan]

Helpful reply,

but may be all the time first value will not be maximum,,,

may be first value is 1000 and second is 1200...

thanks

[israrkhan]

Gysbert Great...

Many Thanks....

[Gabriel]

Hi,

Try this in the expression tab

Num(Sum(Actual) / Sum(TOTAL Actual),'#,#0.00')

This will give you % based upon sum of Actual field, so in your example, your Actual will equal 1969. So each row will be, i.e. 1200/1969 = 0.61.

My question is do you want your % calculated on row above of the total of Actual?

I know this has been answered but something to think about.