Skip to main content
Announcements
Qlik Acquires Upsolver to Advance Iceberg Solutions: READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

2 Replies
erichshiino
Partner - Master

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

Not applicable
Author

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