6 Replies Latest reply on Jul 26, 2013 7:47 AM by Alex Kerin

# Division - Rows in same column

Hi All,

Please find the attached sample workbook.

I want to divide the values in test - Hold portion with columns in test - Err portion.

Ex: 4512 / 108 , 3488 / 76 etc.

I need to show these values in a new column next to the Hold values

Thanks

• ###### 1. Re: Division - Rows in same column

You need to break [search] into two fields based on [test]

• ###### 2. Re: Division - Rows in same column

Can I not use the existing field without adding a new field in the database table?

As it is I want to perform division and display in a new column

• ###### 3. Re: Division - Rows in same column

Similar to this computation but not getting correct values

IF INDEX() = 6  THEN (((lookup(sum([search]), first()+5)/lookup(sum([search]), first()))))/(lookup(sum([search]), first()))

ElseIF INDEX() = 7  THEN (((lookup(sum([search]), first()+6)/lookup(sum([search]), first())+1)))/(lookup(sum([search]), first()+1))

ElseIF INDEX() = 8  THEN  (((lookup(sum([search]), first()+7)/lookup(sum([search]), first())+2)))/(lookup(sum([search]), first()+2))

ElseIF INDEX() = 9  THEN (((lookup(sum([search]), first()+8)/lookup(sum([search]), first())+3)))/(lookup(sum([search]), first()+3))

ElseIF INDEX() = 10  THEN  (((lookup(sum([search]), first()+9)/lookup(sum([search]), first())+4)))/(lookup(sum([search]), first()+4))

END

Please help fix this calculation. I will display computed results next to rows 6,7,8,9,10 in new column.

Should I set compute using? If so to what can I set?

Thanks

• ###### 4. Re: Division - Rows in same column

It's pretty ridiculous to do that when you have a simple solution that just requires you to rethink the way you display your data. The slightest change in the data will screw all of that up.

• ###### 5. Re: Division - Rows in same column

Sure. But how do I approach the problem with the method I have been trying?

• ###### 6. Re: Division - Rows in same column

Hopefully someone else has the time to do that.