Why does CASE WHEN {transaction.type} = 'Estimate' THEN 1 ELSE 0 END work when CASE WHEN {transaction.type} = 'Opportunity' THEN 1 ELSE 0 END does not work on a project saved search??

AI generated answer (using internal Slack threads):

The issue you're experiencing with the CASE WHEN statement in your saved search might be due to the fact that not all transaction types are available in all saved searches. The transaction type 'Opportunity' might not be available in the context of a project saved search, while 'Estimate' is. In NetSuite, the availability of certain fields in a saved search is dependent on the type of record you're searching on. For example, if you're creating a saved search on the 'Project' record type, only certain transaction types might be available for you to use in your search criteria or results. If you're trying to count the number of 'Opportunity' transactions for a project, you might need to create a transaction saved search instead, and then filter on the project. Alternatively, you could try using a formula field in your results to count the number of 'Opportunity' transactions. However, be aware that this could have a significant impact on the performance of your search, especially if you're dealing with a large number of records. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******