Use the Min function. Assuming that your percentage calculation returns a decimal where 1 is shown as 100% with data formatting:
Min ( 1 ; //Put Your Calculation here )
Yea, that worked great – thanks.
Now it turns out I have an additional part of the puzzle.
I set the field as:
Min ( Vacation Options; Vaction Hours Paid Out )
That works fine showing the hours paid out maxing out to the vacation options;
unless 0 hours were paid out, it shows the full amount of the vacation options instead 0.
Is that value 0 or Empty (Null) ?
Make sure that Vacation Hours Paid Out has at least the value of zero and this should not happen. YOu may need to clear the "do not evaluate if all referenced fields are empty" setting on Vacation Hours Paid Out if this is a calculation field.
I had an error in the script - All is good.
Thanks for your help with the "Min" guidance