I have two years of data in one file and need to create difference columns. Below is a simple display of the data I have. I am looking for a way to dynamically create columns such as 'Expense Difference' that will be able to calculate the difference of the two columns based on the name of the field, in this case having 'Expense' in their name. My actual dataset has 30-40 fields for each year and the fields have the same name year over year other than starting with 2018 or 2019.
Solved! Go to Solution.
Got myself confused with the first post.
What you want is the Dynamic Formula from the CReW macros.
I have used it and attached a workflow that should give you the basics of what you need:
Hey @trorvig,
Here is a workflow that may do what you are looking for. This workflow would be dynamic and look for additional metrics as they are added to the data.
I was hoping to avoid adding 37 expressions in a formula tool manually but this definitely would solve my problem!!