Case when formula to show the amount in income statement saved search

AI generated answer (using internal Slack threads):

To show the amount in an income statement saved search using a case when formula, you can create a Formula (Numeric) field in your search criteria. The formula would look something like this:

case when {account.type} = 'Income' then {amount} else 0 end

This formula checks if the account type is 'Income', and if it is, it returns the amount. If the account type is not 'Income', it returns 0. You can adjust this formula to suit your specific needs. For example, you might want to include other account types, or you might want to use a different field instead of {amount}. Remember to add this formula field to your Results to see the calculated values in your saved search results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******