31

All these values are currency.
I smell trouble here ๐Ÿ™„

Comments
  • 0
    @irene all inputs in our UI only keeps 2dp ๐Ÿ˜จ
  • 2
    @irene but .9999999 looks like a float precision error
  • 3
    Looks like someone used binary floating point
  • 0
    @irene I guess this depends on what database is being used for.
  • 0
    This C# xtraReport is killing me ๐Ÿ˜ญ
  • 0
    @irene Can I ask why? ๐Ÿค”
  • 1
    Bitcoin? ๐Ÿ˜‚
  • 0
    @AlgoRythm apples. I mean the fruit๐ŸŽ
  • 0
    you usually use uint128 with one cent being 2^25 to save currencies
  • 0
    Yes indeed~
  • 0
    Those are some weird looking numbers. Too much of a deviation to be straight 'float can't represent this' issues. Please update with the cause when you find it :)
  • 0
    The full story is i got a job to create 2 XtraReport with pivot table.
    The value is in a/b format.๐Ÿ˜“
    (a1 + a2)/(b1 + b2) is not equal to a1/b1+a2/b2, so I can't sum this column from t-sql, but calculate the value during report generation. (.Net c# backend)
    Spend 4 hours couldn't get the number match up...
    Checked in the buggy reports.
    Boss solved the problem without writing single line of code...
    Turns out there's an aggregation option under xtraReport pivotgrid properties๐Ÿคฆ‍โ™‚๏ธ
    Fuck me dead, even Google don't know about it.
    It's time for year review, there's no way to justify the need to raise salary ๐Ÿ˜ญ
  • 0
    @irene another problem is the precision in our t-sql for this row is set to certain value which I didn't pay attention.
    Then I could never get the same value from C# when dividing 2 doubles๐Ÿคฆ‍โ™‚๏ธ
Add Comment