Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Weekly Challenges

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.

SUBMIT YOUR IDEA

Challenge #81: Multi-Level Bill of Materials Problem

cwkoops
8 - Asteroid

I repurposed a macro I use for BOM records that are structured differently....may have possibly just been easier to start from scratch as dealing with "Labor" (130-000), "Galvanising", and "MS Flat 80x8" gave me difficulty, as they show up in the Part Number column of the output multiple times with different "Full Quantity" values.

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1626200922011.png

 

Maskell_Rascal_1-1626200936815.png

 

Cheers!

Phil

Pang_Hee_Choy
12 - Quasar

try no luck to solve with no macro.

Elias_Nordlinder
11 - Bolide

Should probably go Iterative next time, oh well good exercise, managed it in the end still 🙂

 

Spoiler
Elias_Nordlinder_0-1627312657839.png

 

JoePC
9 - Comet

Solution Attached

Hub119
8 - Asteroid

Solution attached.

ncrlelia
11 - Bolide

Challenge 081

AlexC2
8 - Asteroid

Tried doing it without an iterative macro, pretty challenging!

 

Spoiler
AlexC2_0-1629994424092.png

 

MichelleL
Alteryx
Alteryx

Non-macro route . . .

Erin
9 - Comet

Took a little while, but got it! 

 

Spoiler
BronzeFox_0-1632853449729.png