"-" instead Zero

[Nir]

Hi 

Sometimes in measurements I get result as Zero (which ok for me ) but also I can see the sign "-" which not so good for me but i know it is also mean Zero ?

is there a way to avoid this "-" , why i get it instead Zero? 

Thx

[justISO]

Hi, I believe '-' (most of the time in gray background) is not a zero, but rather indicating empty value, no value. In such cases, fore example if you sum([null_value]) you'll get 0 as an answer, same as sum([zero_value]) also =0, so it looks the same, but 0 and NULL are bit different values.

You can try to 'convert' null values to zero with if(isnull([Value]),0,[Value])

[Nir]

GREAT THX , I WILL TRY IT