1 Reply Latest reply: Oct 18, 2016 11:53 AM by Sunny Talwar RSS

    Ref. Number of Calendar Days

    Pogea Gheorghe

      Thank you all for the reply.

      Perhaps my question was not clear, and rephrase again:

      I want to calculate the number of calendar days (in UI) corresponding selections of time (ex. Jan-april and year=2016),regardless of other selections they make (eg. Product, channel...).

       

      Thanks in advance.

        • Re: Ref. Number of Calendar Days
          Sunny Talwar

          Check my response here: Numbers of Days in selection

           

          Max({1<Month = p(Month), Year = p(Year), Date = P(Date), Quarter = P(Quarter), MonthYear = p(MonthYear)>}Date) - Min({1<Month = p(Month), Year = p(Year), Date = P(Date), Quarter = P(Quarter), MonthYear = p(MonthYear)>}Date)

           

          or

           

          Max({1<Month = $::Month, Year = $::Year, Date = $::Date, Quarter = $::Quarter, MonthYear =$::MonthYear>}Date) - Min({1<Month = $::Month, Year = $::Year, Date = $::Date, Quarter =$::Quarter, MonthYear = $::MonthYear>}Date)