Question

Calculate totals per table row in LF 12 cloud

Forms Version 12 Business Processes Ideas How To

Updated one day ago

asked one day ago

I have this table row. I want to calculate total per row. However, when I try to add a new row, the total is carried over to the next row and calculates a total for both rows. It is like it is summing up all the totals

Screenshot from 2025-05-21 07-45-38.png (30.63 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied one day ago • Show version history

What does your Formula look like to total the row? It should look like:

= INDEX(table.field1, ROW()) + INDEX(table.field2, ROW()) + INDEX(table.field3, ROW())

1 0

View 1 previous reply

replied one day ago

I am getting the following error

Calculation contains a circular reference.

Seems the table is not happy to reference itself when looking at the row

0 0

replied one day ago

It works for me without a problem.

0 0

replied one day ago

It has worked. I had a formula that was causing the error. Tried with a new table and collection and the formular worked on both.

Thanks so much Bert

0 0

Replies

replied one day ago • Show version history

Try something like this:

=SUM(INDEX(TableVariable.Field1,ROW()),(INDEX(TableVariable.Field2,ROW()),(INDEX(TableVariable.Field3,ROW())))

0 0

You are not allowed to follow up in this post.

Question

Question

Calculate totals per table row in LF 12 cloud

Answer

Replies

Sign in to reply to this post.