Skip to Content
author's profile photo Former Member
Former Member

To Display Currency /Currency Symbol in Report

Hi All,

Business Requirement:

Want to see Actual and Headcount in same column along with currency.

currently we have separate column for headcount and Actual as below. (Actual and headcount will not come in same row.)

Company Actual Headcount C1 $ 1000 C1 10 C2 $ 1000 C2 20 C3 $ 2000 C3 20 C4 $ 3000 C4 30



To display both in same column , I have used NOT function in formula and displayed the report as Below.

Company Act&HC C1 1000 C1 10 C2 1000 C2 20 C3 2000 C3 20 C4 3000 C4 30



I have calculated the above column using NODIM, so we are not getting $ symbol in report.

But business want that symbol to appear along with Actual value ($ 1000).

Please suggest if there is any way to do this.

Thanks,

Jaya

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on May 09, 2014 at 11:22 AM

    Hi,

    You should have the object currency in the unit-dimension in your query, what happens if you use that?

    Grtz

    Koen

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 12, 2014 at 12:56 PM

    Hello Jay,

    I think Koen Hesters is right. If you use you currency from your unit-dimension you will be able to get currencies in a separate column but not with the figures attached.

    The only thing is that you will get # or not-assigned for the headcount values. If you are using BO tools on top of this BEx report then there is a chance to display currency also in the same column for the Actual values.

    Here check the sample scenario which i tried to develop by looking at your data :

    Kindly click on the screenshot to have a better view.

    Output :

    Regards,

    Ashutosh Singh


    SDN59.JPG (46.0 kB)
    SDN60.JPG (40.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 09, 2014 at 07:41 PM

    How exactly you have joined two KFs? What is showing if you don't use NODIM? Is it * ?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 12, 2014 at 12:20 PM

    Hi Jay,

    I think by removing NODIM $ will display because in your Head count you are showing nothing about unit.

    Also Check out with query properties -> Display -> Tick Display Scaling factors for key figures.

    Regards,

    Abdullah

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.