14 Replies Latest reply: Oct 29, 2013 2:30 PM by OracleUsrName RSS

    Calculate Calendar days - last 3 months in each time period

    OracleUsrName

      Hello all,

       

      I need to calculate the calendar days for the last 3 months in each of the time period present in the report. Here is an illustration -

      Header 1
      YearMonthTotals days in monthTotals days in last 3 months
      2013Jan3192
      Feb2890
      Mar3190
      Apr3089
      May3192
      Jun3091
      Jul3192
      Aug3192
      Sep3092
      Oct3192
      Nov3091
      Dec3192

       

      Can this be done in the analysis or should I create one in the RPD? What is the formula?

       

      Thank you.