11 Replies Latest reply: Jul 13, 2012 3:22 AM by christian juillard RSS

    Set analysis pb

    christian juillard

      Hi guys,

       

      MAy I have your help for a simple problem  I don't understand it doesn't work.

       

      I want to use Set analysis to dosplay the value of N-1 starting for a selected date (from an island table)

      Sales for year is  sum(Sales)

       

      Sales for previous year should be . sum({$<SalesYear = {$(=Only(Cal_An)-1)}>} Sales)

       

      Cal_An is the year which result from a Cal_Date selection (01/05/2012)  and gives only 1 value (2012) and it is stored in an island table detached from other tables.

       

      Nevertheless I 've the same prblem with YTD

       

      I would appreciate an precious help

      Thanks

      Chris