Alteryx Designer Discussions

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

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Number of months in a period in each year

Alteryx Partner

@grazitti_sapna I have 2019.2.5.62427 (admin) where the workflow works, but it doesn't work on 2019.1.6.58192 (non admin). 

It's repeatable for me so potentially could be a bug.


EDIT: I realised that it's because I have custom formulas. YEAR() and DATEADD() are custom ones from here. Workflow attached in my previous response should work. Just changed dateadd() to datetimeadd() and year() to datetimeyear().

6 - Meteoroid

It did! Thanks a lot!

Alteryx Partner

Hi @ailee15 


Without checking the check boxes in the crosstab tool, your results pane would look like:


Without check box.PNG


However, if you do check those boxes, you will capture those details (contract start and end date) as seen below.

With checkbox.PNG

6 - Meteoroid

oh, I get it now. thank you. 


Actually this question was a follow up from my other post (


I have a workflow that does the rest of calculation that I mentioned in the link and realised i'd prefer to do the # of months calculation in WF as well. 


Now i don't know how to combine the two. Can someone help me pls?


Thank you!


Alteryx Partner

I added in my piece of the workflow with the other with some minor tweaks.