Two units for a calculated key figure

Question: Hiho,

quick question (found no answer in the forum yet):

I've to key figures
0Price - Unit USD
0Quantity - Unit PC

When I create in Bex a calculated key figure 0Price*0Quantity
I get as result $ 1000 PC.

I assume that I can define somewhere that I am only interested in $.

But unfortunately I've no clue where?

Can someone help?

Answer:
search the forum on "NODIM",
should do the trick

Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.

Answer:
Thanks. You saved my day.

It is so easy if you know it

Answer:
I don't know it, I am a search expert.


Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.

Answer:
As mentioned the Unit is displayed now currectly. However, there is no sub total calculated. There is just a fat red X.

Any ideas what the problem could be?

Thanks.

Answer:
Create three formulae:
formula1. NODIM($ key figure)
formula2. NODIM (quantity key figure)
formula3. formula1/formula2

You will not get a unit display at all, but you will get totals.
Copyright ?2007 - 2008 www.jt77.com