Expression Help

[Anonymous]

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

[devarasu07]

Hi,

measure is variable   [$(=CTName)]) ? if not just use it CTName

=SUM({$<[Pay Status - Code] -= {"P*"}>} [$(=CTName)]) )

or

=SUM({$<[Pay Status - Code] = {"*"} - {"P*"}>} [$(=CTName)]) )

[agigliotti]

what's the problem ??

[sunny_talwar · Accepted solution]

May be this

Sum([$(=CTName)])