stuck in microsoft report

Question

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

Answer 1

I agree with Remou, you should be using the footers for totals. However if you wanted to carry on with the way you are doing things then try replacing the IIF with NZ(MyField,0)

Answer 2

You should put that IIf statement in the query for that (or those) fields that you want to avoid nulls on. That way you can just put the Sum function in the details section of the report with impunity (assuming details section here).