Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Calculating Variance , Current Month - Previous Month

ankush-agrawal
7 - Meteor

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.

 

2 REPLIES 2
binuacs
21 - Polaris

@ankush-agrawal One way of doing this. I added an extra column 2022_05 to calculate dynamically

 

binuacs_0-1654670328965.png

 

ankush-agrawal
7 - Meteor

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?

Labels
Top Solution Authors