Expand my Community achievements bar.

Working with tables

Avatar

Former Community Member

Hello I am working on a form similar to the one mentioned at "Expanding Table with totals." I got everything to work except for the "Grand Total" it gives the error that the language is not the correct one. Im not sure if that is because the rows in the table will vary according to the client. So when I enter the Sum(Item[*].Total)

It does not work for me.

Can anyone help me with this error?

I appreciate all the help I can get.

Thank you!

2 Replies

Avatar

Level 4

When I need to calculate the total of an expanding table, I use:

$.rawValue = Sum(Item[*].Total);


Place this statement in the calculate event. Make sure you have language set to FormCalc and you have a semicolon at the end of the statement.


Avatar

Former Community Member

Thank you for your feedback, but it proved unsuccessful. I'm not sure if it is due to the rest of the scripts on the table?