Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This one should be easy, i'm just struggling with the correct syntax.
I have the following set which works correct:
=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=LEN(SurgicalSupplyItemCode) = 6"}>}
I'm looking to add the following to it
IsNum(SurgicalSupplyItemCode)<>0
I've tried the following:
=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=LEN(SurgicalSupplyItemCode) = 6"},IsNum(SurgicalSupplyItemCode)<>0 >} SurgicalSupplyItemCode)
=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=LEN(SurgicalSupplyItemCode) = 6"},IsNum(SurgicalSupplyItemCode)-=0 >} SurgicalSupplyItemCode)
=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=LEN(SurgicalSupplyItemCode) = 6"},{"IsNum(SurgicalSupplyItemCode)<>0"} >} SurgicalSupplyItemCode)
May be this:
=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=Len(SurgicalSupplyItemCode) = 6 and IsNum(SurgicalSupplyItemCode) <> 0"}>} SurgicalSupplyItemCode)
or
=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=Len(SurgicalSupplyItemCode) = 6 and IsText(SurgicalSupplyItemCode)"}>} SurgicalSupplyItemCode)
May be this:
=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=LEN(SurgicalSupplyItemCode) = 6"},IsNum(SurgicalSupplyItemCode)<>{0} >} SurgicalSupplyItemCode)
Gives error in expression by the <> i switched to -= and still same thing
May be this:
=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=Len(SurgicalSupplyItemCode) = 6 and IsNum(SurgicalSupplyItemCode) <> 0"}>} SurgicalSupplyItemCode)
or
=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=Len(SurgicalSupplyItemCode) = 6 and IsText(SurgicalSupplyItemCode)"}>} SurgicalSupplyItemCode)
Thanks Sunny! Didn't realize i could use AND int the SET.
This is a search string where we are checking if the two conditions are met. This is a little different from the regular set analysis we use.
Look here: A Primer on Set Analysis