I have a workflow which determines the last three full months and displays parts usage by said months - the output looks something like this:
partID | 2016_03_01 | 2016_04_01 | 2016_05_01 |
partX | 92 | 78 | 66 |
partY | 75 | 60 | 98 |
The dates will change every time the workflow is run in a new month.
I want to calculate the average for each part but as the dates are going to change how can I put this into a formula?
I don't need the dates so am quite happy if these can be renamed to something like Month 1, Month 2 and Month 3 and I can then use the formula tool as normal but I can't figure out how to do this. I've tried using dynamic rename but wasn't sure how to set it up.
Any help appreciated.
Solved! Go to Solution.
Thanks James,
I'm away from the computer now but will definatly give this a try
It got me out of pulling my hair out against JSON deseialisation and serialisation issues so a nice change!
Hi James,
Thanks, this works brilliantly, exactly what I needed
I know this is three years after the fact, but this just helped me immensely! Thank you so much!
5 years later - just used this and saved me some time and stress. Thank you!