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, ...
Forum Discussion
Can you say in words what you want the formula to do?
Sorry,
I�m still not understanding what you want the formula to do. Perhaps you can explain with two examples using numbers and the result you want.
I�m still not understanding what you want the formula to do. Perhaps you can explain with two examples using numbers and the result you want.