Set Analysis two QV Functions

[NickHoff]

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)

[trdandamudi]

May be this:

=Count(DISTINCT {$<SurgicalSupplyItemCode = {"=LEN(SurgicalSupplyItemCode) = 6"},IsNum(SurgicalSupplyItemCode)<>{0} >} SurgicalSupplyItemCode)

[NickHoff]

Gives error in expression by the <> i switched to -= and still same thing

[sunny_talwar · Accepted solution]

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)

[NickHoff]

Thanks Sunny!  Didn't realize i could use AND int the SET.

[sunny_talwar]

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