Null value go to Zero

[sagaraperera]

Dear All

I have a expression and in that include a null value. I want to in that null value become a zero. please refer attachment and give a best solution.

thanks

sagara

[tamilarasu]

Hi,

Go to chart properties - > Presentation tab - > Remove hyphen from Null symbol box and type 0.

[sagaraperera]

Dear Mr.Tamil

Thanks your response

sagara

[Chanty4u]

in script

set nullvalue='0';

[tamilarasu]

Hi Sagara,

If you got the solution, please close the thread by marking correct answer. If not, let us know.

[jonathandienst]

If you need a genuine zero value from a null, use Alt(), eg

     Alt(<your expression>, 0)

[tyagishaila]

Hello,

If you want to make this change in excel sheet,

than Ctrl+f ---->

Find What:    -

Replace with:    0

[amayuresh]

check this link: How to replace null for 0 value in script