Challenge #300: Where is the party?

[vitoriatnrio]

Check it out!

[Justin_Bell]

Spent some time trying to figure out how to trim off the first two characters of a field, "right([Code_name], Length([Code_name])-2)" seems counter-intuitive so if anyone can explain that better it would be fantastic.

Beyond that, formula to *count* new years days made the most sense because then you could filter between 2 and 0 for the output.

Cheers

[Dibas98]

Solution

[GaneshS_Naik]

Spoiler

[oscar_leeper_wf]

Spoiler

[katherinexing]

Attched

[kcollazos]

Great practice for the datathon! 

[lars3033]

Substring([Code_name], 2)

Be careful, because Alteryx uses zero-base indexing ... which means that starting index value of 2 actually starts with the third character