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

Question

Question

10.1 row calculation error

Forms Version 10
Updated July 28, 2016
asked on July 27, 2016

Issue 1:

I am working on a new form in 10.1 and am having an issue with the a row calculation. I am multiplying a field populated by a db lookup by a drop down with assigned values (1 or 0):

=INDEX(Section_Pumps.Value,ROW())*INDEX(Section_Pumps.Y_N,ROW())

Once the first dropdown is selected I get a calculation error on all other rows:

Is there a way to avoid this? I thought about setting a default value on the drop down but was unable to figure out how to reference the field correctly.

 

0 0

Answer

SELECTED ANSWER
replied on July 27, 2016 • Show version history

Hi Cj,

You can work around this if you replace your calculation with

=IF(
    INDEX(Section_Pumps.Y_N,ROW()) = 1,
    INDEX(Section_Pumps.Value,ROW()),
    0
)

since the multiplication calculation is just multiplying by 1 or 0.

Hope this helps!

EDITS: minor formatting, replaced generic variable names with ones from OP

1 0
replied on July 28, 2016

Thanks, that works perfectly.

0 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.

Details
Related Posts
Loading ...