Limit Maximum Value Returned on a Calculation Field

[jsissov]

Using FMP 10.

I manage a database of inventory SKU's using FMP

I need to put a Max Valu Limit on a Calculated Field.

Basically, I'm trying to set up a rule on the Calculated Field that would go something like:

If value >76, value should = 76

 

Any help is much appreciated.

Johnny

[doughemi]

If the field is populated by a calculation, try

 

Min(<YourCalculation>; 76)

 

If the field is populated by a user input, you will have to make it a number field with an auto-entered calculation (with Do Not Replace checkbox unchecked)

 

Min(YourField ; 76)

[Wim Decorte]

A little more verbose but probably easier to understand:

 

Let(

 

_result = <your calc> ;

 

If(

_result > 76 ; 76 ;

_result

)

)