Hide Currency for Each Value!

[Former Member]

Hi ALL

How to hide currency value along with datas in Report Designer??

Thanks

BI Learner

[jagadeesh_mandepudi2]

Hi

In this case you need to apply NODIM for X,Y individually and do the calculations then you dont find any units.

Jagan

[Former Member]

Hi All

Suppose if it is not a key figure, it is a selection, then how can I do it??

Thanks

BI Learner

[former_member205352]

By Selection do you mean something like RKF ?

If thats the case then for eg if ZSEL is your selection then hide this key figure and create a new Formula where you can do NODIM ( ZSEL ) this will take care of truncating currency.

Also directly in Report designer its not possible to truncate currency you need to do at Query level as above.

Hope this helps.

[Former Member]

HI,

It is not possible directly in Report designer to truncate currency you need by selections even.

You need to build a formula on this and use NODIM

Hope it helps

[Former Member]

Hi Praveen/Aduri

Actually it is SELECTION in the column..Even I add that selection in a fomula with NO DIM .. it is not working..

Any other ideas..

Thanks a lot for your response.

[Former Member]

Close it

[Former Member]

Hi

In the formula for that particular keyfigure , use NODIM ( keyfigure)

or NODIM ( Formula)

You can avoid display of $ symbol in the reports

Regards

[Former Member]

Hi

I tried that already..even you want me to set it if we have a formula like "X-Y".as I am not sure whether it is right way to NODIM in the formula as I mentioned above.

Is there anyother idea that I can set it in Report Designer.?

Thanks for your response

BI Learner

[Former Member]

Hi

It is a key figure or Formula ..we can set it ..But what if it is a SELECTION???

Also is there any idea I can set it in Template to exclude the unit & dimensions.