Skip to main content
Question

Trying to set the max value for a field.


I've been using this formula: Min([Value]-[Value Used] , 40) which displays the max at 40. However the actual value of the field continues to go beyond 40. if the actual value is 43 and i subtract 1, it shows as 40 instead of 39. am i using the wrong formula?
This topic has been closed for replies.

Can you say in words what you want the formula to do?