Set Expression

[pascos88]

Hi Experts,

I need to use a set expression in an if condition.. something like this:

if( isnum(ValueChecked)<>0, count (distinct {<DP = {'OHS /Employees'},CompanyName>} CompanyName)  )

If the condition in true I have to count the distinct company name with this set analysis..

Any Suggestions?

Thanks

[dplr-rn]

did you try

count (distinct {<ValueChecked -= {0}, DP = {'OHS /Employees'},CompanyName>} CompanyName)

[mikecrengland]

and maybe remove the extra 'CompanyName':

count (distinct {<ValueChecked -= {0}, DP = {'OHS /Employees'},CompanyName>} CompanyName)

like:

count (distinct {<ValueChecked -= {0}, DP = {'OHS /Employees'}>} CompanyName)

[dplr-rn]

true. missed that