Forum Discussion

Digger's avatar
Digger
Post 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
bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

What value would you expect the total sales to be and how should it be aggregated?

 

_F 11 EBITDA Is also negative so I think your test further agrees with result you're seeing.

 

 

Digger's avatar
Digger
Post Patron
4 years ago

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

  • bcdobbs's avatar
    bcdobbs
    Community 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.