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
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)
Like here:
Zero in red means that you have small negative number. Increase number of digits after decimal point and you will see it!
P.S. If you use formula:
=EPMComparison(,D38,H38,I38)
Use instead formula with rounding to integer:
=ROUND(EPMComparison(,D38,H38,I38),0)
Thank you for your prompt response Vadim. The formula is still showing me the negative value of ZERO.
=ROUND(EPMComparison(,D38,H38,I38),0)
Sorry, but not possible! It's not related to EPM, it's Excel feature.
=ROUND(...,0) will round to integer!
-0.0001 will be rounded to 0!
And you can also try this format without rounding at all:
[Red][<=-500](#,##0,);[>-500]#,##0,_)
It will show thousands, <=-500 will be red!
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
This format formula can be applied to all cells, including data from BPC.
Don't forget accept the correct answer and close the discussion.