Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Go to chart properties - > Presentation tab - > Remove hyphen from Null symbol box and type 0.
Dear Mr.Tamil
Thanks your response
sagara
in script
set nullvalue='0';
Hi Sagara,
If you got the solution, please close the thread by marking correct answer. If not, let us know.
If you need a genuine zero value from a null, use Alt(), eg
Alt(<your expression>, 0)
Hello,
If you want to make this change in excel sheet,
than Ctrl+f ---->
Find What: -
Replace with: 0
check this link: How to replace null for 0 value in script