1 Reply Latest reply on May 20, 2016 9:59 AM by Ivan Young

    Sum in calculated field is not working as expected.

    vinutha vasanthu

      Hi

       

      I have a calculated field i.e straight and simple.Its just summing of 2 measure values.I sum is not working as expected.

       

      Could some one help me out.

        • 1. Re: Sum in calculated field is not working as expected.
          Ivan Young

          Hi Vinutha,

          The nulls in your numeric field, Total Premium Through Manual,  are causing your issues.  You can create a new calculated field, Total Premium Through Manual No Nulls:  zn([Total Premium Through Manual]), and use that in your calculation for Total B premium: [Total Premium Through FTX]+[Total Premium Through Manual No Nulls].  Let me know if you have any questions.

           

          Good Luck,

          Ivan

           

          1 of 1 people found this helpful