4 Replies Latest reply on Jan 21, 2016 9:47 AM by Kyle Mills

    Calculation to return a negative percentage

    Kyle Mills

      I having a problem with a percentage calculation. 

      (SUM([Measure_1]))+MAX([Measure_2])         ***This formula is correct


      (SUM([Measure_1]))+MAX([Measure_2])*0.40  ***This formula is incorrect




      I'm trying to get 40% of the above calculation.  Would like it to return a negative value.


      Thanks in advance to anyone who can help!