is there a formula to get the gross amount in a saved search

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that you can use a formula to get the gross amount in a saved search in NetSuite. However, the exact formula will depend on the specific fields and calculations you need. For example, in one of the threads, a user was able to calculate the average amount per customer using the formula

Sum({netamount})/Count(DISTINCT({name}))

. This formula sums up the net amount and divides it by the distinct count of customers. In another thread, a user was able to get the correct amount by using the field

Amount (Foreign Currency)

instead of

Amount

. This was due to consolidated exchange rates affecting the values. Please note that the exact formula and fields you need may vary depending on your specific requirements and the data you have in NetSuite. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******