2 Replies Latest reply: Nov 6, 2013 1:02 PM by Shuyu Wang RSS

    How to cap a number

      I am measuring the forecast accuracy.

      Forecast=5

      Actual = 1

      Forecast Accuracy = 1-abs(actual-forecast)/actual = 1- 400%= -300% But I need it to be 0%

       

      I'd like to either cap 400% to be 100% or -300% to 0%. Is there a cap function in Qlikview? Thanks!