If to set analysis

[rdsuperlike]

I have below statement:

count(distinct if([Test Result Code] <> ' ' AND [Test Result Code] <> null(),[Serial Number]))

Below set analysis looks correct ?

count(distinct{$<[Test Result Code] -= {' ',null}>} [Serial Number] )

the xpression shows ok but it gives those red line...so not sure

[swuehl]

NULL is not a value, but maybe like

count(distinct{$<[Test Result Code] = {"=Len(Trim([Test Result Code]))>0"}>} [Serial Number] )

[sunny_talwar]

May be this:

Count(DISTINCT {$<[Serial Number] = {"=Len(Trim([Test Result Code])) > 0"}>} [Serial Number])