3 Replies Latest reply: Feb 8, 2010 8:45 AM by adelaida_ioachim RSS

    Problem with Set Analisys formula

      Hello everybody,

      I have a problem with set analysis formula. I try to calculate the valid accounts at month end. I have a calendar table that has a field, MontEnd, calculated as

      IF(DayStart(TempDate) = DayStart(MonthEnd(TempDate)),MonthEnd(TempDate)) AS MonthEnd

      If I write the stock as

      =Count(distinct IF(MonthEnd=date(MonthEnd(AddMonths(Today(),-1))),ACCOUNT))

      I have the right values. If I try to write the same thing with set analysis formula below I have 0 for all dimensions.
      =Count({$<MonthEnd={$(#=date(MonthEnd(AddMonths(Today(),-1))))}>} DISTINCT ACCOUNT)

      Please, can you tell me the write syntax of set analysis in this case?

      Thank you all very much!

      Best regards,

      Adelaida