Calculation between tables

[teruru]

Hi,
Id like to calculate the [TableX.columnA] * [Table.columnB].

How can I calculate with script?

[JHuis]

CAn you give an example of your data?

Why do you want to do this in the script and not in the dashboard? 

[teruru]

thank you for reply.

I share the data.

when I have a data like the pic., I wanna calculate below.
（keys are ID and data.）

cal1）sum(data 2) as ResultA
cal2）data2/ResultA as. ResultB
cal3）data1*ResultB as ResultC
cal4) Sum(ResultC)

 

[Mark_Little]

Hi,

If you want to calculate between table you will need to join them together. 

[teruru]

thank you,

I wanna calculate the number in the same table.