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

BPC10 Reporting - Number format

Hello Experts,

We currently have a requirement to display all data in thousands ('000s) in all our reports. However, the data being loaded into BPC is not in that format.

For example, we are loading the data as sales revenue of $1,234,267.89. However, in our reports, we would like to display this amount as $1,234.27.

Please let me know how we can achieve this in the new EPM Add-in.

Thanks in advance for all your help.

Best regards!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2012 at 08:12 PM

    Hi,

    for showing the numbers without 3 zeros you should go to the format sheet in the emp add-in and select the cell that holds the format of the value , right clic and choose cell format, after that Select Custom from the Category list, and in the Type box enter "#,##0,"(commas can differ with your regional settings), finally refresh your report to see the changes.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Guillermo,

      Thanks for the response. That was very helpful.

      In addition, I also would like to insert empty rows and columns in between reports. For example, Report 000 has a local member in column J, and I would like to start Report 001 in column L, leaving col K blank.

      (I know that in BPC 7.5 we can get this to work by manipulating the row and col key ranges). However, when I create the report 001 in BPC 10 in col L, the col K is being eliminated by the system, and instead the report "moves" to col K. Could you please provide any direction on this?

      Thanks in advance for your valuable response.

  • author's profile photo Former Member
    Former Member
    Posted on Jul 26, 2012 at 04:09 PM

    Hi,

    For doing so you need to use the function EPMInsertCellsBeforeAfterBlock that let you put blank cells whererever you want. For more information about that function you should see the

    EPM Add-in for Microsoft Office User Guide.

    Hope it helps,

    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.