In my Cognos Report i have to show 3 weeks Ago Revenue, 2 weeks Ago Revenue and 1 Week Ago Revenue. Report should execute based on the CampaignID along with the Rundate (CampaignID and Rundates are prompts in my report). The corresponding table have the below details
RunDate:23-Jan-13 weekno: 1 week_start_Date: 20-JAN-13 week_end_date: 26-JAN-13
Pinned topic Need to show 3 weeks ago revenue in my Cognos Report
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-31T11:03:09Z at 2013-01-31T11:03:09Z by Karnatikishor
Karnatikishor 270004FX7M4 Posts
Re: Need to show 3 weeks ago revenue in my Cognos Report2013-01-31T11:03:09ZThis is the accepted answer. This is the accepted answer.for the above we can do back end using the below expression for 3 weeks Ago Revenue
SELECT WEEK_REVENUE FROM
but i want exact function to use inside my Cognos Report.