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

Question

Question

Forms Table DIV Formula Not Working

Forms
Updated March 5, 2020
asked on March 5, 2020 • Show version history

I am trying to divide a field in a table by another field within the same table. Unfortunately, no luck! Below is the formula I am using:

 

=IDIV(INDEX(Table_1. Field_A, ROW(1)), INDEX(Table_1. Field_B, ROW(1))

0 0

Answer

SELECTED ANSWER
replied on March 5, 2020

Oh, you're missing a close parenthesis at the end in your calculation above

1 0

Replies

replied on March 5, 2020

Is that formula inside the table in the same row as the two inputs? Or outside the table? 

For inside the table in the same row, just use ROW() not ROW(1) which will perform the calculation on inputs in the same row as the calculation. 

If the formula is outside the table, don't use ROW(1), just use 1 to denote the first row. 

6.7.0
0 0
View 1 previous reply
replied on March 5, 2020

Yes, both fields are on the same row (Actually there is only 1 row).

I first had it with "ROW()" but that didn't work either. 

0 0
replied on March 5, 2020

If the formula is in the third column of the table, use

=IDIV(INDEX(Table.Num1,ROW()),INDEX(Table.Num2,ROW()))

If the formula is in a field outside of the table, use

=IDIV(INDEX(Table.Num1,1),INDEX(Table.Num2,1))

0 0
SELECTED ANSWER
replied on March 5, 2020

Oh, you're missing a close parenthesis at the end in your calculation above

1 0
replied on March 5, 2020

That did it thank you!!!!

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

Sign in to reply to this post.

Details
Related Posts
Loading ...