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
Thought A at first was calculated by a sum of all previous values in A, not the previous row only. Once I understood that distinction was able to find the solution!
Sometimes we use Alteryx to simplify math.
Other times we do it the opposite way.
Noting that column A is the Fibonacci sequence and applying some series addition we can see that B and C are the n-2th and n-3th terms of same.
Knowing that, we can calculate A directly and B and C from A.
We could go a step further and code a single number that is A*10^12+B*10^6+C and get it done in a single multi-row formula but the coding and decoding would use more tools that we would save on formulas.
