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 ???
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