• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Blanks and Zero's

PaulF

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
 
It's never a good idea to have NULLs in data table.

Depending on your set up. NULLs may be counted as = to 0.

In that instance you want to exclude NULL or subtract count of NULLs from your result.

However, without knowing entire scope of your set up it's hard to tell what may be wrong with it.
 
You must log in or register to reply here.
Back
Top