Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried
SUM({$<[GL Account] -= {324010}>} [Actual Month])
or like this for current selection excluding GL-Account 324010:
SUM({$-1<[GL Account]={324010}>}[Actual Month])
please check the expression that you have written
correct expression is SUM({$<[GL Account]={"*"}-{324010}>}[Actual Month])