why expression return null value

[paulyeo11]

Hi All

i have below expression , but it return null value.

[S_Price]*Currency*sum(Singapore)/sum(BEThailand)

Can some one advise me , how to make it display some value ?

Paul

[sushil353 · Accepted solution]

because,

you are trying to calculate the non aggregated value in a aggregated row..

check this formula .. it should work

sum([S_Price])*Currency*sum(Singapore)/sum(BEThailand)

HTH

Sushil

[paulyeo11]

Hi Sushi

Thank you very much , you have good understanding on aggr.