3 Replies Latest reply on Dec 20, 2016 5:04 AM by Tom W

    Issue in calculation of  measures.

    sneha simha

      Dear All

       

                           I have a set of 5 measure fields comprising of two whole number fields while the other three are in decimal.My final field has to be the sum of all the 5 measures.The calculations will be something like

       

      for measure A if measure A =0 or null then

      (measure A) *0.25

      else measure A

      end

       

      the same will hold good for the rest of the 4 measures.

      The final measure = measure A+measure B+measure C+measure D+measure E here measure A and measure B  are in whole numbers while the rest in decimals so how do i get the sum of all the 5 measures.Kindly help me

       

      Regards

      Sneha