cancel
Showing results for 
Search instead for 
Did you mean: 

Revenue calculation in Transfer Rules

Former Member
0 Kudos
61

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

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

Priya

Former Member
0 Kudos

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
0 Kudos

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