Alteryx Designer Discussions

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

month Calculation

Neffri
8 - Asteroid

Hi,

 

Do you know how to create calculation which will be giving the Corresponding column?

Thank you!

Month table.PNG

6 REPLIES 6
Emil_Kos
16 - Nebula

Hi,

 

There is any rule how the second column was created?

I don't see any pattern in those columns. 

Neffri
8 - Asteroid

It takes the last day of the last month of the quarter and transfer the value for the next 3 months.

Emil_Kos
16 - Nebula

Hi,

 

I hope it will be helpful. 

Neffri
8 - Asteroid

I found one issue with this solution, for example: current 2020-07-31 will 2020-06-31 which isn't correct  because should be 2020-06-30.

Emil_Kos
16 - Nebula

Hi @Neffri,

 

I will take a look for you.

Emil_Kos
16 - Nebula

Hi @Neffri,

 

Thank you for pointing this out. This should work. 

Labels