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

Question

Question

Collections Issue

asked on May 15

I have a collection on my form.  The idea is that the third field will be the summed total of the first two fields.  The issue is that when I add a second row, the third field becomes the summed total of all four fields.  How do I get the calculation to only look at the fields within it's own row?

Collection Issue.png
0 0

Answer

SELECTED ANSWER
replied on May 15

Hi Nick! You want to use the INDEX function and ROW function

 

For example =SUM(INDEX(ChangeOrderAmount, ROW()), INDEX(ContingencyAmount, ROW()))

2 0
replied on May 15

That did the trick. Thanks!

1 0

Replies

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

Sign in to reply to this post.