Percent formula on saved search to show the profit margin of an item using {cost} and {amount}

AI generated answer (using internal Slack threads):

To create a saved search that shows the profit margin of an item using {cost} and {amount}, you can use a formula field in your saved search. The formula for profit margin is (Sales - Cost) / Sales. In terms of NetSuite fields, this would be ({amount} - {cost}) / {amount}. Here's how you can do it: 1. Go to Reports > Saved Searches > All Saved Searches > New. 2. Select the record type for which you want to create the saved search. 3. In the Criteria subtab, define the filters for your search. 4. In the Results subtab, define the columns that you want to display in your search results. 5. Click on 'New Field' and in the pop-up window, select 'Formula (Numeric)' as the type. 6. In the formula field, enter

(({amount} - {cost}) / {amount}) * 100

. This formula calculates the profit margin as a percentage. 7. In the summary type, select 'Group' or 'Sum', depending on how you want to aggregate your data. 8. Click 'OK' to close the pop-up window. 9. Click 'Save & Run' to save and run your saved search. Please note that this formula assumes that your {amount} and {cost} fields are numeric and represent the sales and cost of your items respectively. If your fields have different names or if they are not numeric, you will need to adjust the formula accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******