Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
rangemin(1,1-fabs(actual-forecast)/actual)
rangemin(1,1-fabs(actual-forecast)/actual)
It works! Thank you a lot!