Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center 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().

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