on 2007 Feb 12 2:05 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I was able to figure out the problem and closing this thread
Priya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.