Straight table issue.

[#1]

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.

[Gysbert_Wassenaar]

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.

[stabben23]

Try this Expression:

sum(aggr(IF(Key='200',sum([Area]),Sum([Area]) + Sum({$<[Type]={'Sub'}>}([Area]*-1)))),'Your dimension'))