Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below expression in straight table with one dimension.This expression will give different numbers when I do expression total and sum of rows.Not sure why.
IF(Key='200',sum([Area]),
(Sum([Area]) + Sum({$<[Type]={'Sub'}>}([Area]*-1))))
Thanks Much.
It's because the test Key='200' from the if statement can't be done at the total level. It can only be done at the record level. Key has no singe value at the chart total level.
Try this Expression:
sum(aggr(IF(Key='200',sum([Area]),Sum([Area]) + Sum({$<[Type]={'Sub'}>}([Area]*-1)))),'Your dimension'))