Scenario

A user created a custom field that calculates a value to display the quotient between Quantity (standard line item field) and an Order Quantity (custom line field). However, it is rounding to infinity and they would like it to round to 2 decimal places.

Solution

To resolve, use the ROUND() function.

1. Navigate to Customization > Lists, Records, & Fields > Transaction Line Fields
2. Locate the Custom Field in question
3. Go to Validation & Defaulting > Default Value
4. Edit the formula and use the following format:
   • ROUND({field1}/{field2},2)
     Note: Where field1 is the Internal ID of the standard field and field2 is the Internal ID of the custom line field.
5. Click Save