AnsweredAssumed Answered

Number Calculation Not calculation decimal

Question asked by jakes on Sep 29, 2014
Latest reply on Sep 29, 2014 by raybaudi

Title

Number Calculation Not calculation decimal

Post

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"

For example

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 

Sum(number::field)

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

Outcomes