8 Replies Latest reply: Aug 11, 2014 6:49 AM by Hannan Tariq RSS

    Set Analysis Issue

      I am challenged w a Set Analysis expression.

       

      The following Set Analysis expression is returning NO values;

      =Sum({$<Date={"<=Capture_Date+(vRollPeriod*7)"}>}Sales_Retail)

       

      Whereas the following IF expression IS returning the expected values;

      =Sum(If(Date<=Capture_Date+(vRollPeriod*7),Sales_Retail,0))

       

      Any clues as to why the Set Analysis expression will not return a value?

       

      To add some context, the intent is to provide visibility to Customer Purchases ("Sales_Retail") for a select period ("vRollPeriod") since they were registered ("Capture_Date"). "Date" represents the date of a purchase. Further, "vRollPeriod" is a selection of value that represents a No of Weeks.

       

      Thank you in advance for any help.