equating strings in a expression

[Anonymous]

Am trying to build a bar chart with the below as the expression condition in the chart .

if ((IMP_STATUS = 'End'), count(IMP_ORDER))

but this does not work .  Earlier i was able to use function returning a numeric value in the if condition . Is there a way to compare it ti a string?

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

What about using set analysis:

Count({< IMP_STATUS = {'End'} >} IMP_ORDER)

Hope that helps.

Miguel

[Anonymous]

Thanks Miguel , that works ...