2 Replies Latest reply: May 15, 2014 10:15 AM by Chickenman _ RSS

    Having difficulty totaling

    Chickenman _

      Annoying behavior here: using a summary and want a calculated total of three numeric fields, so SUM(Amount)SUM()SUM().

       

      Amount always has a value but either Field 1 or Field 2 may be null, and if that's the case the total is null. It is fine when all three fields contain a value.

       

      Have tried a number of things to get what seems a simple thing to work including changing options to insert '0' when null to no avail. :mad:

       

      CM