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

 

 

Regards,

Ajay Emmadi

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
)

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super 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.

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    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
)