Sum in a repeating table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

darcone - 20 Apr 2006 17:36 GMT

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.

Reply to this Message

darcone - 20 Apr 2006 20:18 GMT

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.

> 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
[quoted text clipped - 4 lines]
> form. Please let me know if i am doing something wrong because i cannot see
> why the data is invalid.

Reply to this Message