In NetSuite, i've a saved search which has results grouped. One of the filed is a formula which uses Avg. Now in the results column when i again Avg values are not correct.

AI generated answer (using internal Slack threads):

It seems like you're having trouble with the AVG function in a saved search in NetSuite. The AVG function in NetSuite works on a per-field basis. When you use AVG in a formula, it averages the values of each field individually, not the result of the formula. For example, if you have a formula like AVG(Field A + Field B + Field C), it will not give you the average of the sum of these three fields. Instead, it will give you the sum of the average of each field. If you want to get the average of the sum of these three fields, you might need to use a workaround. One way to do this is to use the SUM function in your formula and then divide by the number of fields. For example, (Field A + Field B + Field C)/3. Also, when using division in your formula, you should use NULLIF to avoid dividing by zero. For example, SUM({average cost}/NULLIF({pricelevel2}, 0)). This will prevent errors when the denominator is zero. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******