All these values are currency.
I smell trouble here 🙄

@irene all inputs in our UI only keeps 2dp 😨

@irene but .9999999 looks like a float precision error

Looks like someone used binary floating point

@irene I guess this depends on what database is being used for.

This C# xtraReport is killing me 😭

@irene Can I ask why? 🤔

Bitcoin? 😂

@AlgoRythm apples. I mean the fruit🍎

you usually use uint128 with one cent being 2^25 to save currencies

Yes indeed~

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 :)

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 😭

@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🤦‍♂️