cancel
Showing results for 
Search instead for 
Did you mean: 

Remove Currency Type

Former Member
0 Kudos

When I display the Key Figure Amount in the Column, I have the following result:

Cost Center................Amout

109985......................1385.00 USD

109989......................2385.00 USD

I guess the Currency Type is somehow attached to the Amount. Is there a way for me to remove the "USD" at the back?

If I now restricted the Currency Type = USD, and place this Characteristic in the Characteristic Restriction in the Filter tab in

Query Designer, the Amount Key Figure will be displayed as following

.................................Amout

Cost Center ..............USD

109985......................1385.00

109989......................2385.00

Please advice how I can remove the USD from the output screen.

Thank you.

Edited by: Linda on Sep 23, 2008 3:40 AM

Edited by: Linda on Sep 23, 2008 3:41 AM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

good info

Former Member
0 Kudos

Hi Linda,

you can use "NODIM" function na.. it removes the USD or quantity names etc. wirte as NODIM(AMOUNT).

it solves ur problem,

neelima.

Former Member
0 Kudos

Hi Neelima

Thousand thanks.

However, I noticed that we can only achieve this by using the Calculated KF, is that right?