Add calculated expression on grand total of table

[#1]

hi ,

i have a straight table in qvw

D-Dimension

E-Expression

EO - Expression but this column is not in raw data

Cat(D)     Value(E)       Amount Charged(E)

0-14          100                    50

15-30        100                    25

total                                   75

now i need the below information outside the above table but using the values of above table:

Scenerio 1: if(Cat='0-14' and Amount charged>20, Amount charged*20,0)

Scenerio 2: if(Cat='15-30' and toal>20, total*20,0)

is it possible?

thanks

[#2]

Hi All,

Any luck on this one?

[pauljohansson]

Hi, 

You say that you want a fourth column. Then you say that you want to sum column E. Are you able to clearify what you are looking for?

br Paul

[#4]

Hi team,

any update on the above query

thanks