Revenue calculation in Transfer Rules

[Former Member]

Hello,

I have a simple issue which need to be addressed..

I will have to calculate the Total revenue using quantity and price.And this is the code I have used in the tranfer rules.

RESULT = TRAN_STRUCTURE-/BIC/ZQUANTITY * TRAN_STRUCTURE-/BIC/ZPRICE

I didn't have a syntax error but it is not calculating proper values.

I wrote the same in the query using Calculated KEY figure which displays proper values, but doesn't display the results in currency unit such as $.

Can you please help me?

Thanks

Priya

[Former Member · Accepted solution]

In dimension you will have 0currency? right. Drag this to your rows or filter.

If you see revenue some of the records and not for all, that means, you dont have either price data or quantity data for the other records. If you see some of the records, your routine seems to work.

Ravi Thothadri

[Former Member]

Hi

I was able to figure out the problem and closing this thread

Priya

[Former Member]

Can you try bribging the currency key into your report?

Also, when you have this in trasfer rules after laoding data, are to able to see revenue data in cube as Qty * price

Ravi Thothadri

[Former Member]

Hi,

Can you explain me bringling the currency key into the report?

Yes, I can see some data in the cube, but it is not exact mulplication of

Qty * Price, for some records, values match but nost of them doesn't .

Thanks

Priya