PaulF
Active Member
Hell all...
I have a column that has values or 0,1,2,""
If there are no ""'s then I can use:
TestZero:=CALCULATE(COUNTROWS(testing),testing[Nos]=0) and get the correct count...
but as soon as there are NULLS I get a count of 0's + "" ???
Did I miss something ??
Respectfully,
PaulF
I have a column that has values or 0,1,2,""
If there are no ""'s then I can use:
TestZero:=CALCULATE(COUNTROWS(testing),testing[Nos]=0) and get the correct count...
but as soon as there are NULLS I get a count of 0's + "" ???
Did I miss something ??
Respectfully,
PaulF