This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm kind of stuck in my workflow. If I have 12 months of data in columns and then put in a List Box tool to create an Analytic app against a Select tool so that the user can select two columns for comparison, how do I then create a variance column based upon the two columns? As the 2 columns will change based upon the user setting, I don't think a formula tool would work. Thanks!
Original Data Data after analytic app - two columns will show. I want a to create a variance column.
Thank you so much for the quick reply but I have version 2018.4 so I can't download your workflow. I thought about doing what you were suggesting by replacing the column headers but I wouldn't know what to change the columns to as it will be ever changing.
If I tried to change the "P4" column to "Column A" and the "P3" column to "Column B" so that I can use the formula Column A - Column B, it will then not work out the following month. The following month it will be "P5" column should be "Column A" and "P4" should now be "Column B".
Or if I was using the actual months to make more sense. One month I would want Apr vs Mar, but the following month I would want May vs Apr.