2 Replies Latest reply: May 31, 2011 11:40 AM by Roberto Figueroa RSS

    range with set analysis

    Roberto Figueroa

      Hi all, I'm trying to get a distinct count on the records between a range based on the [YearMonth] selected, this is the expression:

       

      Count(DISTINCT {<YearMonth_Rep = {">=$(=min(YearMonth))"}, YearMonth_Rep = {"<=$(=max(YearMonth))"} >} ReportID )

       

      YearMonth_Rep and YearMonth are numeric values in the form 201101, 201102 for january and february 2011 respectively.

       

      If I use the MIN or MAX part only, the filter works as expected, however trying to get both sentences together doesn't work.

       

      How should I change the sentence?

      Or do you have another recomendation on how to achieve this?

       

      Thanks in advance

      Robert