Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if you want to change the null value in the charts
then use expression : alt(EmloyeeID,0)
HTH
Sushil
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.
Hi Praveen,
Use following at Backend i.e, in scrpting (Ctrl + E)
IF(ISNULL(EmployeeID),0,EmployeeID) AS EmployeeID
Try it once,
Write in script-
NullAsValue EmployeeID;
SET NullValue='0';