Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
did you try
count (distinct {<ValueChecked -= {0}, DP = {'OHS /Employees'},CompanyName>} CompanyName)
and maybe remove the extra 'CompanyName':
count (distinct {<ValueChecked -= {0}, DP = {'OHS /Employees'},CompanyName>} CompanyName)
like:
count (distinct {<ValueChecked -= {0}, DP = {'OHS /Employees'}>} CompanyName)
true. missed that