0 Replies Latest reply: May 15, 2014 9:54 AM by Bruce _ RSS

    Summary Tip

    Bruce _

      Nulls in summaries don't add up!

       

      I was doing a total on a cross summary & found a problem with nulls. The formula was SUM() + SUM() + SUM() + SUM(), but some of the numbers had nulls in them. Once I added calulated fields (if(isnull(x),0, x) the problem went away.

       

      The simple things are always the hardest to figure out!

        :rolleyes: