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))
Basically all it is doing is checking to see if the sum of transaction amounts from the years 2021 & 2022 are empty, as in they never bought anything, and then in the sum of amounts from the years 2021, 2022, & 2023 if they have bought.
I'm trying to replicate this so I can figure out within the results of a search what the total # of "new" customers are within that time-frame. I've just been struggling trying to come up with a solution that does that. Any ideas on how this could be done?
Thanks.