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