Title
Max Calc Field
Post
How would I set up a field that does not calculate over 100%
I have a field that calculates the percentage someone has worked.
However, we want it to max at 100% rather than continuing to calculate
Even if someone has worked over 100%.
Thanks, Carol
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 )