Nulls still not being counted

[mskitty]

After I used the Nz function, and changed the nulls to zeros, it still will not be seen when added to another number. I also tried the Val function and the absolute function.

 

[CJ_London]

please clarify

changed the nulls to zeros, it still will not be seen when added to another number

2+0=2

I also tried the Val function and the absolute function.

val converts text to number

abs converts any negative number to a positive

what have they got to do with the nz function or being seen?

I presume by being seen you mean being counted - if so, how are you counting and what are you counting? provide some example data, the method you are using to count and the expected result from the sample data