Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
I need to combine two saved search summary conditions into one on the results.
Hello,
I'm attempting to figure out if there is a way to combine two different summary conditions into a single formula field on the results of a saved search. The two conditions are:
Summary Type = Sum, Field = Formula (Currency), Description = Is 0.00, & the formula = sum(DECODE(TO_CHAR({trandate},'YYYY'),'2022',{amount},0))+sum(DECODE(TO_CHAR({trandate},'YYYY'),'2021',{amount},0))
The second one is:
Summary Type = Sum, Field = Formula (Currency), Description = Is Not 0.00, & the formula = sum(DECODE(TO_CHAR({trandate},'YYYY'),'2022',{amount},0))+sum(DECODE(TO_CHAR({trandate},'YYYY'),'2021',{amount},0))+sum(DECODE(TO_CHAR({trandate},'YYYY'),'2023',{amount},0))
0