Forum Discussion

Digger's avatar
Digger
Icon for Post Patron rankPost Patron
4 years ago

BUG dividing

How stupid PBI can produce this result? Sales = SUM(debsum) - SUM(CredSum) _F 11 EBITDA = m1 + m2 - m3 // does not matter, take for example 1 _MF 11 EBITDA = DIVIDE([_F 11 EBITDA]...
Need Help
Show and Tell
Tips and Tricks
Digger's avatar
Digger
Icon for Post Patron rankPost Patron
4 years ago

bcdobbs  it should be empty, so only one working way is Round([Sales],2)

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

Ok!


Chsnge the data type of your Sales measure and the underlying columns to currency. I think you're getting issues from floating point arithmetic.