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!
Saved Search: Result Formula for Case When under Case When
Hi all,
I wanted to display a formula result where a Case When is under a Case When, may i know is this something doable?
Tried below code but it is not working:
CASE WHEN (CASE WHEN {custrecord_deprhistdate} = {custrecord_deprhistasset.custrecord_assetpurchasedate} THEN {custrecord_deprhistasset.custrecord_assetcost} ELSE 0 END) IS 0 THEN {custrecord_deprhistbookvalue} ELSE 0 END
Actually i wanted to based on another formula field in the saved search, which is:
CASE WHEN {custrecord_deprhistdate} = {custrecord_deprhistasset.custrecord_assetpurchasedate} THEN {custrecord_deprhistasset.custrecord_assetcost} ELSE 0 END
And set this new formula field value to {custrecord_deprhistbookvalue} if the result from above formula field is 0.