Round Function available on Saved Searches is limited to Round, Round to Tenths, and Round to Hundredths. However, there can be a specific rounding off and format for formula values on Saved Searches (i.e. ”999,999.9999”).
Example: Create a sales search and divide the sales amount by 3. The result should have the format 999,999.9999
Solution
1. Create Transaction Saved Search
2. Click the Criteria tab,
- Type: Invoice
- Select Mainline = Yes
4. Click Results tab > click Columns subtab
5. Field:
Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed
- Select Name
- Select Quantity
- Select Amount
- Select Formula (Numeric)
- Formula: To_char({amount}/3,’999,999.9999′)
4. Click Save and Run
Sample Preview:
| Name | Quantity | Amount | Formula (Numeric) |
| ABC | 12 | 1,000.00 | 333.3333 |
| FGH | 15 | 900.00 | 300.0000 |
| DEF | 14 | 100,300.00 | 33,433.3333 |
“999,999.9999” is the format can be changed depending on the requirement.
Note: Round formula can also be used, however, it will not automatically add commas to values and will not add decimal places to whole numbers.
- Example: Formula: Round({amount}/3,4)
Sample Preview:
| Name | Quantity | Amount | Formula (Numeric) |
| ABC | 12 | 1,000.00 | 333.3333 |
| FGH | 15 | 900.00 | 300 |
| DEF | 14 | 100,300.00 | 33433.3333 |