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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Date Range Formulas and summing YTD
Hey Everyone,
I have a question about summing. I have written the following.
**custbodyforecastdate is a custom date field we tag to all sales orders AND opportunities**
CASE WHEN ( ({transaction.custbodyforecastdate} BETWEEN to_date('1/1/2011', 'MM/DD/YYYY') AND to_date('12/31/2011', 'MM/DD/YYYY')) AND {transaction.type}='Sales Order') THEN {transaction.amount} ELSE 0 END
I am trying to create a search that displays this months sales orders amounts, and the Year to Date amount. However, because I have created a filter that allows users to change the date range as need the YTD formula doesn't pull correctly because of the filter being applied to the criteria!
0