Challenge #41: Analytics PayPeriodCalc

[dashakir1]

Thanks GeneR.

[mdodrajka]

Got the working days with Alteryx way itself. Invested more than couple of hours to derive the formula to get Networkdays like in excel, with no luck. Here's my solution.

Spoiler

 

[PeterH23]

Here's my solution.

Spoiler

[ZenonH]

Slightly different format at the end with regards to column names, but functionally the same. 

Spoiler

[mikeprice17]

My way was different. Recognizing that the first pay period always had a 14 day difference I set up a formula to give it 10 or 11 working days depending on if it was a weekday or not.

The second part was trickier as you could have either 12, 13(LeapYear), 14 or 15 days difference between the start and the end. I made a text input that contained all the combinations (28) and the workdays between the two. Took me about 5-10 minutes to type that up and reason through each option, so not the most efficient but only had to be done once.

[sagarb]

Good use of generate rows tool.

[Chantelb]

Spoiler

[Simonvm9114]

Took a littlebit of a different approach, but the thinking steps are more or less the same. Very educative challange for me when I checked the solution!

[jmt214]

Here's my solution. I feel like it could be more elegant, but it works. 

Spoiler

[johnemery]

Not the most elegant solution, but at least it works.

Spoiler