Challenge #407: Single Biggest Lottery Winner

[robert-headington]

#407

[martinson]

Attempt 1

[mgaronson]

Spoiler

  2 questions - number of one-winner jackpots and highest jackpot amount won by a single winner. 

[KodyKlein]

Thanks!

[Bennu]

T1 is another case of unclear requirements.  Nobody ever one 6/6 of an 'ACCUMULATED' jackpot.  If you take out the 'accumulated jackpot' requirement, then you have a bunch.

Spoiler

[Bennu]

Anyone please DM me if there's a more elegant way than this in Alteryx (maybe a function exists) to convert decimal points to thousand separators and vice-versa

ToNumber(
replace(
replace(
replace([Prize won by each player (match 6/6)],'.',':')
,',','.')
,':', ',')
,2)

[JBevan89]

Solution attached

[jfissel]

Spoiler

[i-godz]

Spoiler

[Arran]

Awesome