Weekly Challenges

benbenjoy · ‎11-25-2019

Shreyasi · ‎11-25-2019

SandeepSK · ‎11-25-2019

My solution as pictured below and attached.

Challenge 190.PNG

bjkay30 · ‎11-26-2019

Here's my attempt at this. After I did this, I realized that I could have concatenated the splits with a sum tool instead of the crosstab/transpose combo, and could have eliminated 4 or 5 extra tools.

Spoiler

ConradW · ‎11-26-2019

complete

dombaikamilla · ‎11-26-2019

Spoiler

markcurry · ‎11-26-2019

Spoiler

Jean-Balteryx · ‎11-26-2019

Here is my solution !

ggruccio · ‎11-27-2019

Had to manually insert the text "[Null]" to get an exact match.

Verakso · ‎11-29-2019

Okay, it has been a while, so this was a nice challenge to get back in the saddle 😉

Spoiler

So here it is, kind of messy, but in the end, I did get to match the result

My Messy Workflow

There was one thing that seemed really odd to me, and that was the field [Total Prior APV] that in the provided result was not Null, but saved as a string with the value "[Null]". I simply do not know why you would do that, but in order to match the result 100% I added the weird function

So here it is, kind of messy, but in the end, I did get to match the resultMy Messy Workflow There was one thing that seemed really odd to me, and that was the field [Total Prior APV] that in the provided result was not Null, but saved as a string with the value "[Null]". I simply do not know why you would do that, but in order to match the result 100% I added the weird function

Still climbing
/Verakso

Weekly Challenges

IDEAS WANTED

Challenge #190: Supply Chain Management Challenge