I am creating some Financial reports against our Oracle GL using Business Objects 4.1.2. I’m working on a P&L and am having some problems with some calculations. The data I currently have looks something like this:
MTD QTD YTD
Equip Revenue 100 200 500
Service Revenue 10 20 50
Total Revenue 110 220 550
The user wants me to add a column “Percentage of Revenue” for MTD, QTD and YTD. I can easily get the correct % for the Revenue portion but I can’t seem to figure out how to get it for the COGS. I need to have each COGS as a percentage of the total revenue. Any help would be appreciated.
I am creating some Financial reports against our Oracle GL using Business Objects 4.1.2. I’m working on a P&L and am having some problems with some calculations. The data I currently have looks something like this:
MTD QTD YTD
Equip Revenue 100 200 500
Service Revenue 10 20 50
Total Revenue 110 220 550
The user wants me to add a column “Percentage of Revenue” for MTD, QTD and YTD. I can easily get the correct % for the Revenue portion but I can’t seem to figure out how to get it for the COGS. I need to have each COGS as a percentage of the total revenue. Any help would be appreciated.
You must add a local variable which computes this value, e.g. COGS/sum(YTD revenue)*100, or something like this, perhaps you also have to modify the “computation driving context” with the (IN or FORALL or FOREACH) operators… Have a look into the on-line help or into the “advanced calculations” manual… (on-line on the CD)
–
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at