Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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.
Hey - yeah it is, I've implemented yours, just gotta wait for the data to reload - looks good!