Divide function returns incorrect results

[Anonymous]

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 have also tried in other ways by using variables but no luck. Kindly help me out of it.

Regards,

Ajay Emmadi

[jdbuchanan71 · Accepted solution]

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]

@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.