朋友发了一个图:
很多金融系统都是吧金额转化为分单位处理的
python复现一样,其他语言没有尝试了,我想着找找规律,找找用例集,方便测试这种数据计算问题
简单脚本:找整数部分2位,小数部分2位,乘数为100,加数为0.01情况下,有多少数据会不准确的
n1 = 0
first1 = "0"
secod1 = "-1"
while n1 < 100:
n1 += 1
if secod1 == "9":
first1 = str(int(first1) + 1)
secod1 = "0"
else:
secod1 = str(int(secod1) + 1)
n = 0
first = "0"
secod = "-1"
while n < 100:
n += 1
if secod == "9":
first = str(int(first) + 1)
secod = "0"
else:
secod = str(int(secod) + 1)
temp = float(first1 + secod1 + "."+first+secod)
# print(temp)
temp1 = temp + 0.01
temp2 = temp * 100
if len(str(temp1)) > 6:
print(str(temp) + "加0.01有问题:", temp1)
elif len(str(temp2)) > 6:
print(str(temp) + "乘100有问题:", temp2)
发现没有啥规律呢!!!!!!!!!!!!!!!!!!!!!
常见解决办法:
1、java用bigDecimal的类处理
2、例如:0.58 *0.01 可以转化为(0.58*100-0.01*100)/100
(0.07 * 10000 + 0.2 *10000)/10000