Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Divide function returns incorrect results

Hello Experts,   I am facing an issue while using the simple Divide fuction. Some of the rows returns correct results while some returns incorrect  results as shown in the below screenshot..  I hav...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    Give this a try, see if it works.

    MAP Value =
DIVIDE (
    ROUND ( SUM ( 'Planning Dashboard'[Closing StockValue] ), 2 ),
    ROUND ( SUM ( 'Planning Dashboard'[Closing Stock] ), 2 ),
    0
)
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

Anonymous 

I am betting that the ones that look like wrong actually have a very small number after the decimal so it is not 0, it is 0.0000056 or something like that.