- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set Analysis Formula Help
I am trying to get the below formula to provide me a 90 day forecast/summation on Total order Amount.
sum({($_3 $<Order__c.AppforBooking_MonthYear={[05-2011]}>} Order__c.Total_Order_Amount2__c)
Unfortunately it returns a null set. Please Help.
Thanx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
The error can be at any point...
but when you use the $_3 you shouldn't use it with the $. It must be one or the other.
sum({($_3 <Order__c.AppforBooking_MonthYear={[05-2011]}>} Order__c.Total_Order_Amount2__c)
or
sum({($_3<Order__c.AppforBooking_MonthYear={[05-2011]}>} Order__c.Total_Order_Amount2__c)
The $_3 means the third next selection. It means that the user had done many selections, moved back (using the back button) three times and you want to go back to that first selection before back buttons. If the user didn't move back, $_3 wil return a null set of records.
Hope it helps,
Erich
(Did the answers at others posts work for you?)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Erich
Thank you for all of the advice...unfortunately the answers to previous posts didn't work, but I appreciate all of your information
Allen