Author Topic: Calculate Monthly report data using Weekending Date  (Read 932 times)

Offline Cognos Man

  • Associate
  • **
  • Join Date: Mar 2021
  • Posts: 1
  • Forum Citizenship: +0/-0
Calculate Monthly report data using Weekending Date
« on: 17 Mar 2021 08:13:31 am »
Hello Gurus

I need to calculate a logic on the basis of Weekending Date in a report for the Monthly report

We have two pages of reports in the report studio
1) Weekly Report with the weekending data (Example: 26/02/2021) Day 1 of the week starts from Saturday to Friday
2) Monthly Report with the month data. I know the monthly calculation to get the data current month data using the below
TRANSACTION_DATE between _first_of_month (_add_months (current_date,0) and _last_of_month (_add_months (current_date, 0)

But here the requirement is how can we calculate based on the Weekending Date. The requirement is to show the previous month data even in the 1st week of next month (New Month)
that is from (01-Mar-2021 to 05-Mar-2021) since the weekending of the weekly report is showing the data for 26/02/2021 (Friday).

This should work dynamically since this is a scheduled report and we are not having any prompt page to select the date ranges since the report take to long to execute.

Please share your ideas and thoughts on this.

Your help is much appreciated.

Yours Sincerely
M Rao