Hello everyone,
What I'm trying to create is a workflow that can run quality assurance tests on data. Essentially, I need to see if the data for a specific day has changed more than 10 percent than the day prior. Right now each column is a day, but the way the workflow operates, the user could select as many days as they desired. The data looks like this:
Right now only one day is present, but in the future users might select ranges of five to seven days. I want, after each date column, for there to be a column that shows the percent change from the prior day, but I can't figure out how to add this dynamically while also keeping the date in the column name.
I've tried using an iterative macro but I can't figure out how to get the column names to work - they'd have to be named something static to work properly.
Any help here is appreciated! This is a challenging problem.
Thanks,
- Bryan
