I am trying to do a calculated field in a query to sum up three fields and below is my formula. However if there are nulls in any of the three field then it does not return a value. I read that you should put like NZ in front of each field in the calculation but that just returned an error message for me. Can someone advise what I would need to do to this formula to ignore a null value and sum up the other fields?
Contract Value Calc: [Reports]![Value]+[Reports]![Services]+[Reports]![Maintenance]