Put a condition in a lookup
Input:
| A | B | C | D | E |
| France | Germany | Spain | Portugal | Sweden |
Calculate :
| B | C | D | E | |
| Origin country | France (A) | Germany (B) | Spain (C) | Portugal (D) |
| Actual Country | Germany (B) | Spain (C) | Portugal (D) | Sweden |
Hello,
I would like to know if you can help me with the formula for "Origin Country".
It is supposed to send me the information from the previous step to the current step as in the example above.
For the actual country line it's simple but for the first one I don't know how to do it.
Thanks in advance
Tagged:
0
Best Answer
-
Create a system module for mapping , this might help!
https://community.anaplan.com/t5/Anaplan-Platform/NEXT-or-Previous-cell-values-without-Time-dimension/td-p/588930
