In Netsuite i have a formula numeric field which has average function, am doing a average when am grouping. This search has Show Total checked. But the bottom row doesnt show correct value. When use Sum as grouping, its adding correctly.

AI generated answer (using internal Slack threads):

In NetSuite, when you are using the 'Group' function in a saved search and have 'Show Total' checked, the total will not show up at the bottom of the report if the summary type is 'Average'. This is because the 'Average' function calculates the mean value of the group, not the total sum. If you want to see the total sum at the bottom of the report, you need to change the summary type to 'Sum'. This will add up all the values in the group and display the total at the bottom of the report. However, if you are using a formula in your saved search, you need to ensure that the formula is compatible with the 'Sum' summary type. For example, if you are dividing two fields in your formula, you may need to use the NULLIF function to avoid errors when one of the fields has a value of zero. Here is an example of how you can use the NULLIF function in your formula:

SUM({field1}/NULLIF({field2}, 0))

. This formula will return the sum of

field1

divided by

field2

, but if

field2

is zero, it will return null to avoid a division 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. ******