formula case when to show the line item in a transaction saved search

AI generated answer (using internal Slack threads):

In order to show the line item in a transaction saved search using a formula case, you can use the following steps: 1. In your saved search, go to the 'Results' subtab. 2. Click on 'New Field' to create a new formula field. 3. In the 'Summary Type' dropdown, select 'Group'. 4. In the 'Formula' field, you can write your case statement. For example, if you want to show the line item only when the quantity is greater than 10, you can write:

CASE WHEN {quantity} > 10 THEN {item} ELSE NULL END

5. In the 'Label' field, you can give your formula field a name, for example 'Item when Quantity > 10'. 6. Click 'OK' to save your new field. This will add a new column to your saved search results that shows the line item only when the quantity is greater than 10. Remember, the

{quantity}

and

{item}

are placeholders for the actual field IDs in your NetSuite account. You need to replace them with the actual field IDs that you want to use in your case statement. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******