In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Divide 2 dates into months

Somvanshi
5 - Atom

I have 2 dates Period Start and Period End and 1 amount column in my data. I want monthwise amount based on these dates.

For e.g. if Start Date is 25 Apr 2021 and End Date is 30 Jun 2021, total amount is 2000 then i was the bifurcation if amount based on month like for 5 days of Apr the amount similarly for whole month of May and then June.

3 REPLIES 3
binuacs
21 - Polaris

@Somvanshi Can you provide the expected output based on the input file provided?

Christina_H
14 - Magnetar

Is this what you want?

Christina_H_0-1664378365044.png

 

egregorio001
5 - Atom

Hey @Christina_H, This helped us a lot today. Thank you!

Labels
Top Solution Authors