How to cap a number

[#1]

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!

[Gysbert_Wassenaar · Accepted solution]

rangemin(1,1-fabs(actual-forecast)/actual)

[#3]

It works! Thank you a lot!