Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Question
1
Views
0
Comments
Joe Choueiri-Oracle
Joe Choueiri-Oracle Rank 5 - Community Champion
edited Aug 13, 2024 3:40PM in Oracle Analytics Cloud and Server

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