How to round up decimal values in saved search

AI generated answer (using internal Slack threads):

To round up decimal values in a saved search in NetSuite, you can use the

ROUND

function. The syntax is

ROUND(n, integer)

, where

n

is the number you want to round, and

integer

is the number of decimal places you want to round to. For example, if you want to round a number to 5 decimal places, you can use the following formula:

TO_NUMERIC(field,'0.00000')

. If you want to round up the sum of a formula field, you can use the

CEIL

function. However, you need to be careful with the order of operations. If you want to sum the results first, and then round up, you should nest the functions like this:

CEIL(SUM({qty1},{qty2}))

. In this case, you should not use the summary type of SUM, and instead use the formula as

CEIL(SUM(

. In a summary search, use AVERAGE, and in the formula use

CEIL(SUM(your expression))

to get the desired result. Please note that summary types can be tricky with saved searches. They have their good uses for sure, but they can limit flexibility in a lot of cases. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******