Having trouble calculating due dates

[RCern]

Hello everyone,

I have the attached workflow where I have a series of items that were scanned into a system.  I have a goal (number of days) for when those items should be due.  I need Alteryx to calculate the date due based on the number of days the goal represents without counting Saturday, Sunday and Holidays.  

In the attached workflow, I would expect Alteryx to tell me that the item scanned in on 5/1 would be due on 5/6 since the goal is 3 days and Saturday and Sunday need to be excluded.

I would expect the item scanned on 6/27 would be due on 7/7 given the holiday and weekends in between.  etc. etc.  

What am I doing wrong with the multi row formula that it is not looping and calculating correctly or is my whole approach wrong?

[alexnajm]

Happy to help @RCern 

[RCern]

@alexnajm The reason why I asked is because when I run the workflow, the filter tool before the summarize tool only produces 1 result for me where as it produces 3 results for you.

[alexnajm]

Download my workflow and it works - you can use the Compare Workflows option to see where the differences lie

[RCern]

@alexnajm So sorry to keep bothering you.  When I download your workflow from yesterday the Filter tool at the end only generates 1 result.  I have tried downloading it multiple times.

[alexnajm]

What version of Alteryx do you have? Do you have grouping functionality in the RecordID tool? My guess is that you have a version that doesn't... in which case you can recreate a grouped record ID using a tile tool or a multi formula tool

[RCern]

@alexnajm Ahh.  I'm running Version 2023.1.1.361.  My RecordID tool does not have grouping functionality :(

[alexnajm]

There it is - then you can create a grouped record Id as mentioned above - it should look something like this in the end so you can filter to where the goal matches the record ID within the overall record