Skip to Main Content
Forums

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!

show prior calendar month up to 5th working day of the current month

Joe Choueiri-OracleMay 21 2016 — edited May 21 2016

Hi

If you can help please.

I want to have a formula that allows me to do the following- image attached.

Any day I run the report within the period of time between May 09 and June 08 then I get data for May 01 until June 06 ( 5th working day of the month) and so on...so if I run the report on June 07 then I get From June first until July 8 (5th day of the month).

Thanks

Joe Timeline for SCA.png

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 18 2016
Added on May 21 2016
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
0 comments
423 views