Expression Issue

[#1]

Hi,

I was wondering why the condition in this expression for a measure is not valid?

count({<left(adjmt_id ,2) = '05'>} adjmt_id)

Thanks,

Ben

[m_woolf]

You can use IF:

count(if(left(adjmt_id ,2) = '05', adjmt_id))

Or you can create a new field in script:

left(adjmt_id ,2) as NewField;

Then:

count({<NewField = {'05'}>} adjmt_id)

[Anonymous]

I think you can NOT Evaluate or do functions ON THE LEFTSIDE of Modifiers ...

But anyway

check with this

count({<left(adjmt_id ,2) = {"05"}>} adjmt_id)

or

count({<adjmt_id={"=left(adjmt_id,2)=05"}> adjmt_id)