alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #41: Analytics PayPeriodCalc

15 - Aurora

I wanna get paid twice

Spoiler
15 - Aurora

Solution attached

9 - Comet
Spoiler

8 - Asteroid

solved

8 - Asteroid

Challenge #41:

Spoiler
flow

Formulas:

Spoiler

Give everyday a number:

Switch(DateTimeFormat([Start],"%a"),

0,

"Sun",0,

"Mon",1,

"Tue",2,

"Wed",3,

"Thu",4,

"Fri",5,

"Sat",6)

Formula for days diff:

IIF([Start]>[End],

Null(),

1 +

((DateTimeDiff([End],[Start],"days")*5 - ([StartWeekday]-[EndWeekday])*2) / 7) +

IIF([EndWeekday]==6,-1,0) +

IIF([StartWeekday]==0,-1,0)

)

10 - Fireball

Solved

5 - Atom

Solved

6 - Meteoroid

Very helpful, would love to go back and solve with RegEx tool!

8 - Asteroid

My solution attached

10 - Fireball

my solution :)

Spoiler