Forum Discussion
Divide function not showing correct result
Hi community,
I'm trying to use the divide function but it's not showing the correct results for me. The formula looks like this:
Omloopsnelheid = DIVIDE(SUM(GRV_StockpositionsPerDay[Stock]);SUM('100_Voorraadmutaties'[Eruit positief]);0)
The GRV_StockPositionsPerDay[Stock] is the 'Voorraadstand' in the first picture. The 100_Voorraadmutaties[Eruit positief] is the Eruit posititief in the second picture. So what I want is 65.401,00 / 700.348,00 = 0,09338... But it's giving me 0,00290.
Anyone who knows how to tackle this problem? Thanks in advance!
Kind regards,
Dexter
it seems that the two table is not properly related.
Look to whats append if you bring the "Eruit positief" column in the first table.
If you don't solve post the pbix, i'll try to take a look.
GP
4 Replies
If I just divide the columns without using DAX it gives the same answer. Also when I use divide the numerator and denumerator need a function I believe.
it seems that the two table is not properly related.
Look to whats append if you bring the "Eruit positief" column in the first table.
If you don't solve post the pbix, i'll try to take a look.
GP
Thank you GP, when you said relation I checked into the relation between the tables and thats fixed it! :)
