Set Analysis Formula Help

[#1]

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

[erichshiino]

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?)

[#3]

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