Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Number of months in a period in each year

Highlighted
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().

Highlighted
6 - Meteoroid

It did! Thanks a lot!

Highlighted
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

Highlighted
6 - Meteoroid

oh, I get it now. thank you. 

 

Actually this question was a follow up from my other post (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Split-over-contract-period/m-p/433621#...)

 

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!

 

Highlighted
Alteryx Partner

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

Labels