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

Question

Question

I would like to divide the value in one column with the value in another column within the same row.

Updated November 16, 2017
asked on November 16, 2017

The table will have multiple, dynamic rows.  Columns A&B are filled via SQL lookup.

We are looking to Divide the value of column A with Column B and display the results in column C.

I tried: =DIV(INDEX(Table.Hours,ROW()),(Table.Good_Pcs.ROW()))

There is no error and no data in the 3rd column.

 

If I use =DIV(INDEX(Table.Hours,ROW()),2)

It works.  So, I am guessing my issue is with the Table.Good_Pcs column.

 

Any suggestions?

 

 

0 0

Answer

SELECTED ANSWER
replied on November 16, 2017

Oh, I see the issue now. You need the INDEX for each column, but your example only has it for one of them and on the second it has .ROW() instead.

Try this:

DIV(INDEX(Table.Hours,ROW()),INDEX(Table.Good_Pcs,ROW()))

1 0

Replies

replied on November 16, 2017

My first suggestion would be to check the Type of that column. If it is not a "number" type, then the formula will not work.

0 0
replied on November 16, 2017

The 3 in question are Number fields.

0 0
SELECTED ANSWER
replied on November 16, 2017

Oh, I see the issue now. You need the INDEX for each column, but your example only has it for one of them and on the second it has .ROW() instead.

Try this:

DIV(INDEX(Table.Hours,ROW()),INDEX(Table.Good_Pcs,ROW()))

1 0
replied on November 16, 2017

Great!  That was it.  Thanks!

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

Sign in to reply to this post.

Details
Related Posts
Loading ...