Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
You are correct, joining the tables was an unneccesary step.