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 use Case When formula with different types of summary?
Hi,
I have this formula in a saved search:
MAX({projectedamount})-SUM({applyingtransaction.netamountnotax})
I have it like this since I need to do the operation between those fileds that have diferente types of summary and in this way it gives me the expected results but I would like to include it in a case where statement, I try this way but it shows error
CASE WHEN {custbody_h3_oportunidad_cerrada}='T' THEN MAX({projectedamount})-SUM({applyingtransaction.netamountnotax}) ELSE 0 END
Do you know what i'm missing?