topic Calculation between two tables in a script in App Development

Calculation between two tables in a script

evansabres — Fri, 29 May 2020 16:53:41 GMT

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 — Fri, 29 May 2020 19:26:53 GMT

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 — Fri, 29 May 2020 19:47:30 GMT

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