Discussions

 View Only
  • 1.  Trying to set the max value for a field.

     
    Posted 03-19-2019 15:16
    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?


  • 2.  RE: Trying to set the max value for a field.

    Posted 03-20-2019 00:44
    Can you say in words what you want the formula to do?


  • 3.  RE: Trying to set the max value for a field.

     
    Posted 03-20-2019 15:34
    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.


  • 4.  RE: Trying to set the max value for a field.

    Posted 03-20-2019 18:35
    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.


  • 5.  RE: Trying to set the max value for a field.

     
    Posted 03-20-2019 18:57
    X-Y=Z.
    Z cannot exceed 40.


  • 6.  RE: Trying to set the max value for a field.

    Posted 03-20-2019 20:10
    From your description of the problem it looks like you are using Max instead of Min, , despite the fact that you posted that you were using Min in your formula.

    If you were actually using Min, I suggest that you double check what values are actually in those two fields that are in the formula.