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
All,
I used the optimization tool for the bonus part, as it gave me a good score, but not as high as the solution.
-Never the less, it was a great introduction to the Optimization tool vice Macros.
-Please tell me what you think.
Matt
@griffinwelsh as an accountant, this was the scariest workflow I've ever created 😱. Fun way to learn the optimize tool
All results match except for 'fear of regulatory non-compliance' which is 1,802 not 1,807 as per the answer. Can someone help me understand what I am doing wrong?
@RuWa The issue with your result for "Fear of regulatory non-compliance" is your multi-row formula and you kind of got lucky there weren't more issues since your formula looks at the prior fields value regardless of Fear.
This is the result that caught up to you,
Your formula: iif(isnull([Fear Intensity]),[Row-1:Median Intensity per Fear],[Fear Intensity])
Corrected formula: IIF(ISNULL([Fear Intensity]), [Median Intensity per Fear], [Fear Intensity]) no need to use multi-row formula
