Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to exclude specific GL Codes from Invoice Amount.
For e.g.
sum({$<[GL Code]=E({'ABC',XYZ'})>}[Invoice Amount])
Any idea how I can achieve this?
Try
=sum({$<[GL Code] -= {'ABC',XYZ'} >}[Invoice Amount])
and ignore the bug in the expression editor highlighting the minus equal as error.
Try
=sum({$<[GL Code] -= {'ABC',XYZ'} >}[Invoice Amount])
and ignore the bug in the expression editor highlighting the minus equal as error.
Worked. Thanks