I keep thinking this should be easy but the answer is evading me. I would like to transform the value in each row of a column based on another column's value.
First cell in eff column is result of multiplication of Qty and rate and second cell is result of First value in Eff cell and 2nd value in rate column and so on. But the problem is as my product changes I need to perform same calculation for that product as well. For example in below table my product changes to B in table, i need to perform same calculation for that as well. Kindly help
[TABLE="width: 722"]
<tbody>[TR]
[TD]Index
[/TD]
[TD]Product
[/TD]
[TD]QTY
[/TD]
[TD]Rate
[/TD]
[TD]Eff
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]AC
[/TD]
[TD]1
[/TD]
[TD]0.9811
[/TD]
[TD]0.9811
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]ACC
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]0.9811
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]ACCC
[/TD]
[TD]5026
[/TD]
[TD]0.9278
[/TD]
[TD]0.9102
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]AD
[/TD]
[TD]2034
[/TD]
[TD]1
[/TD]
[TD]2034
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]ADA
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]2034
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]ADAA
[/TD]
[TD]1
[/TD]
[TD]0.9
[/TD]
[TD]1830.6
[/TD]
[/TR]
</tbody>[/TABLE]
First cell in eff column is result of multiplication of Qty and rate and second cell is result of First value in Eff cell and 2nd value in rate column and so on. But the problem is as my product changes I need to perform same calculation for that product as well. For example in below table my product changes to B in table, i need to perform same calculation for that as well. Kindly help
[TABLE="width: 722"]
<tbody>[TR]
[TD]Index
[/TD]
[TD]Product
[/TD]
[TD]QTY
[/TD]
[TD]Rate
[/TD]
[TD]Eff
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]AC
[/TD]
[TD]1
[/TD]
[TD]0.9811
[/TD]
[TD]0.9811
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]ACC
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]0.9811
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]ACCC
[/TD]
[TD]5026
[/TD]
[TD]0.9278
[/TD]
[TD]0.9102
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]AD
[/TD]
[TD]2034
[/TD]
[TD]1
[/TD]
[TD]2034
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]ADA
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]2034
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]ADAA
[/TD]
[TD]1
[/TD]
[TD]0.9
[/TD]
[TD]1830.6
[/TD]
[/TR]
</tbody>[/TABLE]