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

Comparing one Row to other Rows with a calculation

Started by Taqwa, 01 Nov 2006 03:33:36 PM

Previous topic - Next topic

Taqwa

Hi,

I'm new to this forum and new to COGNOS 8.

I need some help please.

I have to build a report, with Revenue, and Direct and Indirect labor, as rows.Ã,  Revenue is a positive number, the labor expenses are negative.Ã,  The Revenue is a single line, however, the labor categories will be broken down to their GL Accounts, about 7 in each.Ã,  So, if there are 7 lines in each labor category, and 1 line for revenue, that totals 15 rows.Ã,  I need to get a % to Revenue column on this report.Ã,  A column that gives me the % of the labor expense to Revenue, NOT the % to Total (which would include Revenue).Ã,  How can I do this?Ã,  I have been working on this for longer than I care to mention and I would appreciate some wisdom.

TQM ???

almeids

TQM-
   I'm not on C8 yet but this generic approach should work...you need to get revenue by itself, so create a calculated data item like:

       rev_fact=if ([your_category_column]='Revenue') then ([your_measure_item]) else (0)

   and use it in your calculation:

       pct_of_rev=[your_measure_item]/total([rev_fact])

   Depending on the structure of your report you may need to use the for clause in the total function (e.g. total([rev_fact] for [some_group]) ), you may also want to use conditional formatting to suppress the display of the percentage on the revenue line(s).
HTH
Steve