Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Me again!
I have the following expression that a colleague has been using:
Sum({<[Pay Status - Code]={'P'}>}[$(=CTName)])
How do I amend it properly (I've tried, and I'm getting weird and wonderful) to pull everything back, and not just those marked P?
Thanks in advance,
Gareth
Hi,
measure is variable [$(=CTName)]) ? if not just use it CTName
=SUM({$<[Pay Status - Code] -= {"P*"}>} [$(=CTName)]) )
or
=SUM({$<[Pay Status - Code] = {"*"} - {"P*"}>} [$(=CTName)]) )
what's the problem ??
May be this
Sum([$(=CTName)])