Can I divide {fields1} by {fields2}

AI generated answer (using internal Slack threads):

Yes, you can divide

{fields1}

by

{fields2}

in NetSuite. This can be done in a saved search or a formula field. For example, if you have two fields,

field1

and

field2

, and you want to find the percentage of

field1

to

field2

, you can use the following formula:

sum({field1})/nullif(sum({field2}),0)

. This formula will calculate the sum of

field1

and divide it by the sum of

field2

. The

nullif

function is used to avoid a divide by zero error. If the sum of

field2

is zero, the function will return null instead of causing an error. Here is an example of how you can use this formula in a saved search:

code
sum({field1}+{field2}+{field3})/nullif(sum(nvl({debitamount},0) - NVL({creditamount},0)),0)

In this example, the formula calculates the sum of

field1

,

field2

, and

field3

and divides it by the difference between the

debitamount

and

creditamount

. If the difference is zero, the

nullif

function will return null to avoid a divide by zero error. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******