Bulk edit issue with 0.00
This was working fine until 2 months ago or so. I was using bulk edit to add in multiple fields this value 0.00
When I now try bulk edit and enter 0.00 in field, I got value 0 (just zero, without decimal dot and double zero after). This is making me problem because the formula field is not working anymore.
I did have this formula working previously
((Total_Payroll + 1.8 + Payroll_Fee) * Exchange)
when I put 0.00 via bulk edit in fields Total_Payroll, Payroll_Fee and Exchange the formula was working. So I used bulk edit to assign this 0.00 to those 3 fields:
Total_Payroll, Payroll_Fee and Exchange
((0.00 + 1.8 + 0.00) * 0.00) and the formula was working
Now when I try to assign 0.00 to those 3 fields, I got in each field just 0 and formula is not working anymore
((0 + 1.8 + 0) * 0)
Manually the formula works if I add manually to each field 0.00, but with bulk edit it just converts 0.00 in formula non-working 0.