Exclude amount from Total

[#1]

Hi,

I'm trying to add an expression into my chart that shows the sum of Actual Amount which excludes the items that relate to a specific ledger account (324010). I've tried the following;

SUM({$<~[GL Account]={324010}>}[Actual Month])

and

SUM({$<[Actual Month]={"*"}-{324010}>}[Actual Month])

but each time my chart shows the Total of the actual amount without subtracting the amount relating to 324010 - is there a way of doing this please?

Thanks,

Caroline

[swuehl · Accepted solution]

Have you tried

SUM({$<[GL Account] -= {324010}>} [Actual Month])

[danieloberbilli]

or like this for current selection excluding GL-Account 324010:

SUM({$-1<[GL Account]={324010}>}[Actual Month])   

[preminqlik]

please check the expression that you have written

correct expression is SUM({$<[GL Account]={"*"}-{324010}>}[Actual Month])