I have two fields that I am multiplying against each other. Each field is in two different tables but are synced through a unique identifier field. When I multiply them I have the following basic formula.
My problem is that for each row of the KM field I want to multiply a different variable against it. I used dynamic update to do this originally but cannot use it on a server. I want to give the ability to basically change the KM field.
My first attempt was the following with each variable.
Note: 300 in the first if statement would actually be a variable and each other number below would be a variable as well that the user could change.
The problem here is that unless I selected one of the strings in that unique identifier field it would just multiply everything by 10. Which I don't want. It would work, but I had to select as an example 'ConstructionGas2016Alberta486' and it would only work for that one.
I then though why not just create a specific set analysis statement for each row instead of the if statement which I tried the following.
This worked a bit better but would still give me data for provinces that were not associated with Alberta as an example.
There are 600 rows in the KM field with a variable already created to adjust it. Originally the variables were changed as a number you wanted to add or subtract from the "baseline" value in the KM field and then you a created a dynamic update script that would add/subtract the table based on updated variables.
Any ideas on how to replace the dyanmic update method would be extremely helpful!!