Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)