formatting of currency values in kmmsplits table
Chris
DeveloperChris at rebel.com.au
Tue Nov 15 00:01:03 GMT 2022
I was going through the database tables when a file was stored as sqlcipher.
I came across something I haven't seen before and I was wondering why it was
that way
Transaction values are stored as text strings but with unusual divisors.
For example the value 18.95 may be stored as "1895/100" which is 1895
divided by 100 = 18.95. All and good
but there are other ones which confuse me as to why its done this way.
Examples are ...
unformatted => formatted
258/25 => 10.32
124/25 => 4.96
-273/50 => -5.46
1/2 => 0.5
Can some one explain why it is done that way?
Chris
More information about the KMyMoney-devel
mailing list