Challenge #22: Identify Values to Aggregate

[Illya]

My Solution

[justindavis]

Spoiler

[SamDesk]

Spoiler

Sam

[aihnen]

Solution attached.

Spoiler

Ended up using REGEX to tokenize by "/atm2.\d+\.{0,1}\d{0,2}", then used REGEX replace in order to get rid of the"/atm2." and change to a number. From there used Transpose and summed by RowNum using the Summarize tool.

[JamesCameron]

My effort.

Spoiler

[danicahui]

Spoiler

[Kale_Malcom]

Spoiler

[Nicholas_Bignell]

Nice challenge and love that it we the original one