Ignoring null fields in count or average

[prologqueen]

Please can someone help me with this formula? I've been searching for days on how to get an average of 2 fields while ignoring the "null fields". (ie., the average of (2, null) should be 2 not 1)

I thought by adding the two fields together and then dividing by the count I could get the answer (see below). But I'm running into the same problem where it is counting the null fields. Any ideas?

sum([{@PM Schedule new},{@Super Schedule New}])/count([{@PM Schedule new},{@Super Schedule New}])

Prologqueen
tkaye@bozzuto.com