IsNull function behaviour

[konidena]

Hi Team,

I am using IsNull function in my script.

I have columns called Region, SalesRep, Sales.

LOAD * INLINE [

    Name, SalesRep, Sales

    HYD, sravan, 2000

    Pune, Madhu

    Delhi, Srinivas, 3000

    Banglore, Bhuvan, 15000

    Chennai, Karthik, 17000

];

NoConcatenate

Load *,

If(IsNull(Sales),Sales,0) as NewSales

Resident Details;

Drop table Details;

Question: For the SalesRep Madhu, the sale is Null.

Isnull Function returning "0" in the column "NewSales" for madhu. But, it is not showing the sales values where the actual sales is happend.

How to get the Actual sales as well as 0 in the "NewSales" field.

Regards

Srinivas

[konidena]

If(IsNull(Sales),0,Sales) as NewSales is not working. Still it is showing Null value instead of 0