Need help in Table Calculations using SQL query in Confluence Table Transformer Macro

[Jitendra Shembekar]

Hi

Trying to get multiplication result in the last column of the below table. I am using table transformer sql query. Query itself does not give any error but it gives below error after publishing it.

Please help.

Table used

Range	Actual Value	C1	C2	Multiplication
20	21	1	100
30	29	0.5	50
40	88	0.5	50

• Want to put multiplication of C1 and C2 values under Multiplication column
• SQL used in Table Transformer is
  • UPDATE T1 SET T1.'Multiplication' = T1.'C1'*T1.'C2'
• Error I am getting
  • TypeError: Cannot read properties of undefined (reading 'C1')

How to resolve this?

[Stiltsoft support · Accepted solution]

Hi @Jitendra Shembekar ,

Please use the following query for the case:

UPDATE T1
SET T1.'Multiplication' = ('C1' * 'C2');

SELECT * FROM T1

[Jitendra Shembekar]

Excellent ... that worked!

Thanks a lot @Stiltsoft support