### 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 )