Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
)
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
)
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.