How to show the results of an IF statement where it's not included as the dimension

[Dayna]

Hello All,

I have an IF statement with a bit of Set Analysis in it, this expression does exactly what I want when the gltr_acc is included as the dimension. However, I don't want this as a dimension, and when I remove gltr_acc from being a dimension it seems to only sum the value.

My expression is:

=

if(gltr_acc='06200',sum({$<pt_part_type = {"R*"}>} gltr_amt),if(gltr_acc <> '06200',sum(gltr_amt

)))

The sum of rows should equal -5179.61 but when I remove gltr_acc from being a dimension it's -105023.42

Please help!!

Kind Regards,
Dayna

[suniljain]

pls check the link between fact and dimention table.

pls share application if you can. it will also help us to find exact root of problem.

[Dayna]

Hello Sunil,

The link is fine, as if the account is included as a dimension it works as it should.

Unfortunately, I cannot upload the document due to the sensitivity of the data..

Kind Regards,
Dayna

[deepakk]

hi Dayna,

Is this the same problem which we were discussing in the previous forum. then check out that I got a solution for it.

[Dayna]

Hey - yeah it is, I've implemented yours, just gotta wait for the data to reload - looks good!