This discussion is archived
14 Replies Latest reply: Oct 29, 2013 12:30 PM by OracleUsrName RSS

Calculate Calendar days - last 3 months in each time period

OracleUsrName Newbie
Currently Being Moderated

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points