Skip to Content
avatar image
Former Member

SAP BPC EPM REPORTS SHOWS ZERO AS NEGATIVE IN REPORT. HOW DO I CHANGE THE FORMAT SETTING

Dear Experts,

I have a weird scenario where one of my EPM report is showing the result as ZERO in negative. (0) in RED. Tried all the ways to change the format values in the EPM formatting sheet. Can someone suggest me what could be the possible error?

Best Regards

Siddhu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    Dec 02, 2016 at 05:24 PM

    Ups, due to the bad quality of your format setting picture I didn't understand that you show thousands!

    Then you have to round to thousands:

    =ROUND(EPMComparison(,D38,H38,I38),-3)

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2016 at 01:52 PM

    Zero in red means that you have small negative number. Increase number of digits after decimal point and you will see it!

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2016 at 03:04 PM

    P.S. If you use formula:

    =EPMComparison(,D38,H38,I38)

    Use instead formula with rounding to integer:

    =ROUND(EPMComparison(,D38,H38,I38),0)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 02, 2016 at 04:47 PM

    Thank you for your prompt response Vadim. The formula is still showing me the negative value of ZERO.

    =ROUND(EPMComparison(,D38,H38,I38),0)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 02, 2016 at 05:09 PM

    Applied the formula =ROUNDDOWN(EPMComparison(,XX,XX,XX),0) as well

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2016 at 06:05 PM

    And you can also try this format without rounding at all:

    [Red][<=-500](#,##0,);[>-500]#,##0,_)

    It will show thousands, <=-500 will be red!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 05, 2016 at 02:49 PM

    Hello Vadim,

    Excellent and thank you very much for breaking this. This is working for me and i can see the results as expected.

    Also i will have to try the later formula """"[Red][<=-500](#,##0,);[>-500]#,##0,_)""""" as well.

    Best Regards

    Siddhu

    Add comment
    10|10000 characters needed characters exceeded