Subject: Displaying key figures without currency unit in BEX reports

[Former Member]

Hello,

Is it possible to display key figures without currency unit in BEx reports? For example; Material Costs 1000 EUR

should be shown as 1000. Currency unit EUR and also scaling factor (*1000 EUR) does not interest us.

When we use display options in query properties, we just see an option of displaying key figures with/without scaling factors, which does not solve our problem.

Thanks for your reply.

Regards,

Nuran Adal

[Former Member · Accepted solution]

Hi Nuran,

You can create a new formula and use in it NODIM() function.

Best regards,

Eugene

[Former Member · Accepted solution]

Hi Eugene,

thank you very much for your quick reply. We have very detailed reports with min. 10 columns, I should have defined 10 more formula columns to realize this (NODIM), but anyway there is no other way to do this, am I right?

Best Regards,

Nuran

[Former Member · Accepted solution]

Hi Nuran,

Knowing this problem I usually define my KFs as amounts, without units of measure and currencies. And add into the cube one char for units and another one for currencies.

Best regards,

Eugene

[Former Member · Accepted solution]

Hi Eugene,

I understand, thank you again Eugene. It was really helpful answer:)

Regards,

Nuran