3 Replies Latest reply on Sep 29, 2014 10:17 AM by raybaudi

    Number Calculation Not calculation decimal

    jakes

      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