3 Replies Latest reply: Oct 9, 2013 12:16 AM by Chris Valiquet RSS

Key Figures  Currency and Unit of Measure Display option turned off

Vir Josh
Currently Being Moderated

Hello,

 

Using existing report from SAP ByD. Inventory summary by materials. On Key figures  like Inventory value shows up with Amount and adds USD or other currency. Similarly On Qty key measure adds the "each", "pack", "gal" in the report.

I don't want to display the this currency or key unit of measures. How to remove from the report show only display the numbers

like "1000" instead of "1000 USD".

I have try to look into the Key measure setting and couldn't found any options for hide. Any idea or suggestion will  be great.

 

Thanks,

Vira.

  • Re: Key Figures  Currency and Unit of Measure Display option turned off
    Christian Happel
    Currently Being Moderated

    Hi,

    I didn't find a report called "Inventory summary".

    But I tried it with other reports and I don't think there's a possibility to not display the currency or unit.

    May I ask why you don't want to see that?

    Best regards, Christian

  • Re: Key Figures  Currency and Unit of Measure Display option turned off
    Sunil Mohan Bhandarkar
    Currently Being Moderated

    Hi Vir,

    Try Going to the Keyfigure tab of the Amount or Quantity View Element which you have set as key figure. in this tab there is a field called Currency/Unit Reference and usually this is where you maintain the charecteristic which populates the USD Each etc. remove the charecteristic maintained here. This should remove the USD etc from the keyfigure while displaying in the UI

     

    Regards

    Sunil

  • Re: Key Figures  Currency and Unit of Measure Display option turned off
    Chris Valiquet
    Currently Being Moderated

    Wow, this response is only almost 2 years later than the post.  But I needed this so I'll share...

     

    Edit report in Report Wizard, under Select Key Figure choose Create.  Give your new Key Figure a Name and then Next to Formulas.

     

    The Formula is NODIM("original key figure name")

     

    like

     

    NODIM("Net Without Freight Charge Amount (Document Currency)")

     

    NODIM() is under the Data button.

     

    Be sure to select the newly created key figure to be in your report, and then in the report layout add it to the key figures displayed under Settings -> Key Figures.

     

    It's actually in the docs on the reports formulas page.  But it did take me a while to find it.

     

    And the reason you often don't want UoM is for exports to excel so it's a numeric field ready to go for additional calculations.

Actions