Saturday, October 20, 2018

Compare Two or More Fields To Display the Highest Value


There are three custom fields in the sales order form of type Decimal Number and user would like to create a fourth field that will display the highest value among the three.

1. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New.
2. Provide a Label (e.g. Highest Value).
3. Set Type to Decimal Number.
4. Unmark Store Value checkbox.
5. Under Applies To tab, mark the Sale checkbox.
6. Under Validation & Defaulting, set Default Value to GREATEST({custbody1},{custbody2}, {custbody3})
7. Mark the Formula checkbox.
8. Click Save.

No comments:

Post a Comment