Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Restricted Key figure - Displaying as normal number instead of currency

Hello,

I'm creating a restricted key figure using 0AMOUNT which of course is currency, however in the cube that I'm using 0AMOUNT is used for both Dollars and Quantities. The problem is 1) it is always displaying a $ symbol in front of the key figure and 2) it seems when I try to create a calculated key figure and try to add the 0AMOUNT to another 0QUANTITY infoObject I get an error (I'm presumming because I'm trying to add a number to a currency infoObject).

So my question(s) are 1) Can I format my new restricted key figure to always display as Quantity even though it's a currency info object

and 2) Can I do a calculated key figure adding a Currency InfoObject to a Quantity infoObject?

Thank you very much!

-Patrick

Former Member
Former Member replied

1) For your first question, u don't to have the currency dollar displayed for the restricted 0amount instead you want the unit of quanity.?if you want to do this,you could make use of Excel's format options i.e go to

format-->.Style->Select the stdBexInput item and make the appropriate settings.

2) You can use NODIM() function to add two different keyfigures.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question