Forum Discussion

HaoHao's avatar
HaoHao
Qrew Trainee
6 years ago

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?
Formulas and functions

5 Replies

Sort By
    • HaoHao's avatar
      HaoHao
      Qrew Trainee
      6 years ago
      the formula takes a vacation balance, subtracts a number days used to deliver the total available. The max available will always be 40. 

      it works currently, however instead of capping at 40 it only displays 40 instead of the higher value.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      6 years ago
      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.