Hello,
I am using this quarantined time to learn more about Alteryx. I put together a workflow to calculate price, volume, and mix change for some sample sales data over a three year period. I am trying to make this workflow dynamic so when the periods change the calculations will still work. For example my test date I used 2016, 2017, and 2018 but next year it could be 2018, 2019, and 2020 or it could be 2018, 2019, and TTM Sep 2020. I have held off trying to incorporate the trailing twelve month calculation for now because I have received the follow error messages just using annual data.
When I try and test my macro using the same sample data I get some error messages saying "The field "Y1_Volume" is not contained in the record {Action=Sum}"
There was a step in my workflow where I used a select tool to change the column name from 2016 to Y1_Volume, my attempt to normalize the periods. However, it looks like that step in the workflow isn't working when I test the macro.
Any ideas how to solve this issue?
