Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calculate Calendar days - last 3 months in each time period

OracleUsrNameOct 4 2013 — edited Oct 29 2013

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

Year	Month	Totals days in month	Totals days in last 3 months
2013	Jan	31	92
	Feb	28	90
	Mar	31	90
	Apr	30	89
	May	31	92
	Jun	30	91
	Jul	31	92
	Aug	31	92
	Sep	30	92
	Oct	31	92
	Nov	30	91
	Dec	31	92

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

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 26 2013

Added on Oct 4 2013

#11g, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #date, #report, #time

14 comments

1,068 views