why isnt this saved search formula with maximums ummary working : CASE WHEN ({applyingtransaction.type} = 'Vendor Bill') then REPLACE(NS_CONCAT(DISTINCT({applyingtransaction})), ',', ' | ') else ' ' end

AI generated answer (using internal Slack threads):

The issue with the saved search formula seems to be related to the use of aggregation functions like

MAX

and

NS_CONCAT

within the

CASE

statement. In NetSuite saved search, aggregation functions cannot be used within a

CASE

statement. The formula

CASE WHEN ({applyingtransaction.type} = 'Vendor Bill') then REPLACE(NS_CONCAT(DISTINCT({applyingtransaction})), ',', ' | ') else ' ' end

is not working because

NS_CONCAT

is an aggregation function and it's being used inside a

CASE

statement. To resolve this issue, you could try to restructure your formula to use the

CASE

statement within the aggregation function, not the other way around. For example, you could try something like this:

MAX(CASE WHEN {applyingtransaction.type} = 'Vendor Bill' THEN {applyingtransaction} ELSE 0 END)

Then, you can apply the

REPLACE

function to the result of this formula in a separate step. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******