Yes but in this instance a Null isn't really a Zero. if there is a Zero in the Date column that material still has a monetary value, and that $dollar number would affect the total sum of port merchandise if included in a position that is blank.
Doesn't Nz return zeros? That is not what I am wanting.
The data that I am looking at if it is null will eventually become a date, but I don't want a total for the stuff that is blank right now.
I was also thinking maybe I am trying to use expression in a different order then they need to...
I am trying to sum a Group in a report if the values in the report are not null. We are trying to track inventory as it moves through the shipping phases and have information that is provided to us in spreadsheets, if the event hasn't yet happened the spot if left blank. I am trying to sum the...