If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

calculation

Started by kalyan_sekhar1, 20 Aug 2008 09:30:05 AM

Previous topic - Next topic

kalyan_sekhar1

Hi,


I got a report where in i need to do a calculation between the actual and target for the month and also comparision with same month of previous year.


Month Mar-07 Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08
Actual 210 210 230 230 230 230 230 230 230 230 240 250 245 250 260
Target 220 210 240 240 240 240 240 240 240 240 240 240 240 240 240
Year Compariosion             106.5% 108.7% 113.0%
Month Comparision 95.8% 95.8% 95.8% 95.8% 95.8% 95.8% 95.8% 95.8% 95.8% 95.8% 100.0% 104.2% 102.1% 104.2% 108.3%



As you can see from the above table (some dummy data), the month comparision is the division of Actual/Target for each month. Where as Year Comparision is between Actual/Target of the month of this year / actual/target of the same month of previous year.


In the above e.g. (Mar -08 Actual /Target) / (Mar 07 Actual/Target) is compared.


Please let me know how i can achieve the same in the reports.


Thanks