Calculating Variance , Current Month - Previous Month
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello I have a data set for which I keep adding Current Month data into excel.
Alteryx workflow is designed in a way that it groups the data at account level with months as column.
I need to add variance column at the end which calculates variance between current month minus previous month.
I perform this exercise in first week of every month and Current month Data means data of last concluded month.
For eg:
Expectation in June: Current Month Data (2022_5)- Previous Month (2022_04)
Expectation in July: Current Month Data (2022_6)- Previous Month (2022_05)
Attaching the data set for reference.
Solved! Go to Solution.
- Labels:
- Dynamic Processing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much. It worked for me.
However, I would like to understand the expression used in Dynamic Select. Can you please elaborate?
Also in the summarize tool at last, you have used Max as function while summarising variance, any particular reason for it?