Replacing Null values

[praveenkumar_s]

Hi,

     I want to replace the EmployeeID null value as 0. what can i do to get that as i join three table containing EmployeeID

[sushil353]

if you want to change the null value in the charts

then use expression : alt(EmloyeeID,0)

HTH

Sushil

[#3]

You can achieve this in two ways either in script or in chart. In chart go to presentation tab change the null value represent from - to 0.

If you want to achieve this in script level check for null value while loading from source change the value there it self.

you can use isnull or coalesce function bro.

[#4]

Hi Praveen,

Use following at Backend i.e, in scrpting (Ctrl + E)

    IF(ISNULL(EmployeeID),0,EmployeeID) AS EmployeeID

[tyagishaila]

Try it once,

Write in script-

NullAsValue EmployeeID;

SET NullValue='0';