Calculated column based on dynamically created table values

[G One]

Hi,

I am trying to create columns for dynamically created tables after clicking on one of the button in my Dashboard.

Scenario:

User is entering part number in text area and clicking on button to generate values in below tables:

I have below 2 dynamically created tables:

Table A:

 

 

 

Col_A_Part

Col_B

Col_C

Col_D

Col_E

Col_F

 

 

Part A

1.87

14.50

3.78

5.40

3.24

 

 

 

Table B:

 

 

 

Col_A_Part

Col_B

Col_C

Col_D

Col_E

Col_F

 

 

Part B

1.22

28.19

3.73

7.49

1.98

 

 

Part A

0.59

19.58

2.84

2.73

0.60

 

 

Part C

0.50

17.46

0.39

2.40

2.68

 

 

Part D

0.29

10.09

1.92

1.28

1.43

 

 

Part E

1.03

27.57

4.10

1.94

2.22

 

 

 

 

I needcolumns which calculates average of ratio like below:

1. Avg(Table A.Col_B/Table B.Col_B, Table A.Col_C/Table B.Col_C, Table A.Col_D/Table B.Col_D, Table A.Col_E/Table E.Col_B, Table A.Col_F/Table B.Col_F)

for e.g.: Avg(1.87/1.22, 14.50/28.19, 3.78/3.73, 5.40/7.49, 3.24/1.98)

Note: If numerator value is greater than denominator value thenneed to swap numerator with denominator and denominator with numerator like below:

For e.g:Avg(1.22/1.87, 14.50/28.19, 3.73/3.78, 5.40/7.49, 1.98/3.24)

Similarly I need to Iterate in Table B for all records in Table B and have to take the ratio with record which is available in Table A:

Can anyone help me on this scenario that either Python script or Data functions can be implemented to achieve this scenario.

Thank you..!