3 Replies Latest reply on Jan 9, 2019 9:37 AM by Simon Runc

    Sum'ing together Measures

    tb582

      I have three measures - I want to ADD THEM TOGETHER for the life of me it isn't working!

       

      my current field is like so

      IF STR([Validation bool])="f" then 1 else 0 end

      so I can put this on my sheet and it shows the desired number. Which is good.

       

      I have three other fields just like the above that all produce their desired numbers but I can't ADD them all/total them for the life of me!

        • 1. Re: Sum'ing together Measures
          Deepak Rai

          try

          zn(sum1)+zn(SUM2)+ZN(SUM3)

          • 2. Re: Sum'ing together Measures
            Jim Dehner

            Hi Tony     

            if you have separate measures then create a new calculated field     sum(measure1) + sum(measure2) + sum(measure3)

             

             

            Jim

             

            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

            • 3. Re: Sum'ing together Measures
              Simon Runc

              Hi Tony,

               

              So you should be able to use

               

              zn([Measure 1]) + zn([Measure 2]) + zn([Measure 3])

               

              The ZN equates a NULL to Zero, which is needed when adding across measures (1 + NULL + 1 = NULL not 2). When nulls appear in a single column the NULLs won't get counted or added in a sum, but across measures we need to use the ZN

               

              Hopefully that's it, but let me know if that doesn't solve it