Number Calculation Not calculation decimal
I have 2 tables.
Table 1 - Items
Table 2 - line Items
In my line items, I have a number field that is set to "As Entered"
Number field with current data in the related line items table
Record 1) 35.52
Record 2) 34.76
Record 3) 34.72
In my (parent) items table I have a calculation that is
The calculation is not recognizing the decimal. The total it is displaying is 10494
The correct total is:104.94
If I use the comma it works, I don't want to use the comma, I need to use the decimal as the user will be entering the decimal