how to dispaly mixed currencies??

[Former Member]

Hi,

I am using NODIM data function in my report (BEx Query Designer), as we know NODIM is suppressing the mixed Currencies/Unite of that particular Key figure.

But by using NODIM I should display the mixed currencies in my report.

if it is not possible then please tell me which data operator is acting as NODIM with display mixed currencies.

my formula:-  NODIM(Opening Balance)>0 * NODIM (Opening Balance) + NODIM (Opening Balance)<=0 * 0

regards

Mohammed

[former_member184768]

Hi,

Couple of points:

• Is it possible for you to put the currency infoObject (like 0LOC_CURRCY or Document Currency) in the drilldown. With this you would be able to display the currency independent of the NODIM calculated column.
• You can also try adding calculation like: (NODIM(Opening Balance)>0 * NODIM (Opening Balance) + NODIM (Opening Balance)<=0 * 0) * (Opening Balance/Opening Balance). This should add the currency unit to the calculation. Please check the that the Opening Balance is not equal to 0. If it is, you may want to add NOERR or something similar to that.
• Please note that with mixed currency, you may not be able to see the aggregated data with multiple currencies involved. It may show * instead of the value.

Regards,

Ravi