i want to create formula show only transaction created from journal entry

AI generated answer (using internal Slack threads):

To create a formula that shows only transactions created from journal entries, you can use a CASE statement in your saved search formula. The CASE statement will check the transaction type and return the value only if the transaction type is 'Journal Entry'. Here is an example of how you can do this:

sql
CASE WHEN {type} = 'Journal Entry' THEN {internalid} ELSE NULL END

In this formula,

{type}

is the field that contains the transaction type and

{internalid}

is the field that contains the transaction ID. If the transaction type is 'Journal Entry', the formula will return the transaction ID. Otherwise, it will return NULL. You can replace

{internalid}

with any other field that you want to display in your saved search results. For example, if you want to display the transaction date, you can use

{date}

instead of

{internalid}

. Please note that this formula should be used in the Results subtab of your saved search, not in the Criteria subtab. Also, make sure to select 'Formula (Text)' as the summary type for this field in the Results subtab. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******