Skip to Content
0
Former Member
Oct 26, 2005 at 02:05 PM

How do I achieve this. Report with Compunded InfoObject

15 Views

Hello Experts,

I have a problem with my reports.

The probelm starts with compounding of InfoObject <b>Item</b> with <b>Verson</b>.

Ths scenario is as follows.

We have an ODS which stores the financial data.

We have Item and version as part of ODS key. We store amount for each Item depending on version. There are 2 versions. European Version and US Version depending on various tax rules. The amount in case of European version is stored as full value and the amount in case of US version is stored as delta value. We are supposed to calsulate US full value as sum of European full value and US delta value.

Now

I have a report which fetches European Full vaue in 1st column and US Delta value in 2nd column. and a 3rd column with a formula to calculate the sum.

The data in ODS look like this.

Item Version Amount

1001 EU 1500

1001 US 200

The above report looks like this

<b>Item___EU Full_____US Delta____US Full</b>.

EU/1001____1500_____0_____1500

US/1001_____0_____200_____200

as the infoobject Item is compunded with version.

But i want to show like this.

<b>Item____EU Full____US Delta____US Full</b>

1001_____1500_____200_____1700

How can I get rid of this compounding in the report.

Message was edited by: Suneetha

Message was edited by: Suneetha

Message was edited by: Suneetha