Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
Now, you can stay up-to-date with the latest discussions, helpful tips, and important announcements, all delivered straight to your inbox. Whether you’re looking to catch up on what you missed or just want a quick overview, our email digest has you covered. To learn more and to subscribe, click here.
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.