I want to compare the average data in table1 with a new derived field in table2, which is calculated by subtracting 3 times the Sigma value (Avg - 3xSigma). None of the currently used methods can achieve this.

Initially, I used Table Transposer to transpose the data, aiming to apply a mathematical formula to the transposed fields. However, since the field type became β?β after transposition, it was impossible to perform calculations.

Is there a better way to compute values between columns?
Thank you.

@tqAkshay95 Hello, table.xlsx (11.8 KB)
I combined the two tables into one file. I hope that the output table will only have the calculated row (1_Avg_-3Sigma) and the original rule data can be removed.

@yogesh_nawale Hello, Iβve encountered another problem. When changing the calculation from β-β to β+β, its type changes, and it canβt be converted to doubleβ¦ The picture is below: