Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to resolve the Invalid Expression in Saved Search?
I'm trying to create a formula wherein if the location is for a specific location, it will only return the amounts from 2 specific accounts.
------------------------------
Example: When the location = location A, it should return amount from Account 1 and Account 2.
Type of saved search: Transaction
Result column summary type: Row
Problematic formula: CASE WHEN {location}='Location A' THEN CASE WHEN {account} IN ('5121 Freight Costs : Freight Out GA','5529 Freight Costs : Freight Out FL') THEN {amount} ELSE 0 END