Group Footer Sum Function Returning Incorrect Value

[fourkings]

I am trying to sum a field in my group footer (in the form of decimals, i.e. --> 0.1, 0.035 etc). However, the summed result is completly wrong. In the group footer I used the following: =sum([group field name to sum]). Please advise.

 

[lynchg]

What is the datatype of the field you are summing? Will it take decimals? It would be helpful if you gave an example of what is wrong with it, pick a group and list the values in that detail section along with the sum value you are getting in the footer.

 

[fourkings]

The datatype of the field I am summing is number. Example group values: 0.09; 0.05; 0.03 the group sum output is: 21.00