Calculation between two tables in a script

[evansabres]

I have two tables in my script, 'Reference' and 'Sales' They are joined by a common field called 'Price Scale Display'

Within the 'Reference table is a field called 'Price'

Within the 'Sales' table is a field called 'Seats'

Within my script, i would like to multiply those two fields together to create a new field called 'Revenue'

How can I achieve this?

[dplr-rn · Accepted solution]

why do you need to do in script? you can do that in expression.

if you have to do in script you will need to join the tables together and then perform the multiplication between 2 fields

[evansabres]

You are correct, joining the tables was an unneccesary step.