How to convert null() to 0

[sculptorlv]

Hello..

I have data in my LOAD statements, where one Employee have a value while another has not any records about it.

How can I convert null() values to 0

I have tried the LOAD statement bollow, but it doesn't help.. one employee still has "-" value instead of 0

Load

  Employee,

  IF(Coffee_Rent = null(),0, Coffee_Rent) AS Coffee_Rent

RESIDENT Another_Table.

[sculptorlv]

I am not sure how to use it..

And the result is the same:

[sculptorlv]

Thank you all guys!

I found my problem!

I used two parameters for Employees with the help of JOIN. As the result, for some Employees were not presented in the first LOAD statement.

For my needs I started with the full list of empoyees and then  sed rangesum function.