You are viewing limited content. For full access, please sign in.

Question

Question

For each column, row 4 should equal that column in row 1 + row 2 - row 3

Forms Layout Designer Forms
Updated June 21, 2024
asked on June 20, 2024

I'm using Laserfiche Forms Professional Version 11.0.2212.30987.

I have a fixed table, where in column 3, I need to add row 1 and row 2 and subtract row 3, and display the answer in row 4. 

I tried the following, but received a "Calculation contains a circular reference." error:

=IF(ROW()=4,
INDEX(Leave_Credits_Table.Vacation,1)+INDEX(Leave_Credits_Table.Vacation,2)-INDEX(Leave_Credits_Table.Vacation,3)
)

I realize it would be easier to just change my columns to rows and vice versa, but I need to try to match an existing PDF form.

0 0

Replies

replied on June 21, 2024

Calculations can not differentiate between recursive and circular and will not allow either.  Only javascript can accomplish this task. See post for more details

https://answers.laserfiche.com/questions/212829/Why-is-this-a-circular-reference-in-calculations-How-do-you-reference-the-row-above-you-in-a-table#213159

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...