My report is containing some null value. 

Report is generated through query

In my report I am calculating sum of every field for that I had written =iif((field name) is null,0,sum(field name))

Through this function I am getting result as 0 only if field contains some value as well