10 Replies Latest reply on Apr 26, 2017 10:05 AM by Selim Mejia

    Dividing Two Measures in a Calculated Field

    shareq.mohammed

      Hello Experts,

       

      Real simple: I am trying to divide two measures in a calculated field but not getting the desired answer. I tried SUM() for Numerator and Denominator as well but no luck. Can some one please help. Thanks in advance.

        

      Quantity=37,873
      Sales=$2,297,201
      Answer=$0.02 

      but instead of 0.02 I am getting 1,387 (See image below)

       

      Calculation1 =