ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community has implemented a new single sign-on experience. If you are having issues with your account, please review the FAQs.

Alteryx Designer Discussions

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

Number of months in a period in each year

8 - Asteroid

@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!

9 - Comet

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!


8 - Asteroid

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