Sum in a repeating table

[darcone]

I have a repeating section with a nested repeating table. Both the section
and table are pointing to 2 different db tables. In the footer of the
repeating table i have a filed bound to the db table of the repeating section
with the sum() function in it. But whenever it does the calculation i get
invalid data error. The sum is correct except it puts a lot of 0 behind the
decimal. I have made all these fileds format to currency in both the db and
form. Please let me know if i am doing something wrong because i cannot see
why the data is invalid.

 

[darcone]

Upon further investigation i descovered that the sum() function may not be
working correctly. I can add a .01 and everything comes out fine in the total
but i can than change it to .05 and i get invalid data. The number that
appears in the total field says ".050000000 etc." so during the calculation
something is throwing it off but i cannot find what it is.