Please, help me to solve the issue. I have a Flat list with the -1 and 1 values. I have a Hierarchical list consisted from the same code from the flat list but in the hierarchy. There are more than 15 levels. I want to assign every -1 or 1 from the flat list to every element in the hierarchical list. The value for summary levels should be taken from the flat list, not from kids.
Re: Move values from flat list to hierarchical list
Hi @Artem.shchaulov! This is not an easy question. And I think you are already aware of all the basic restrictions (LOOKUP with a formula, etc.).
My suggestion is as follows: 1. Create a technical list (via import). The name is the same as that of FLAT List. Code: FLAT Code & 1 / -1. 2. You find element of TECH Flat list with FINDITEM. 3. You get his code. 4. Through the formulas of the text, you get from there 1 / -1 at the end of the code. 5. Everywhere there summary = formula.
The example in the picture is attached. This is not a perfect description, but I think the general approach is clear. When writing formulas, one should follow the Anaplan practices for working with text. For demonstration purposes, I have not made perfect formulas.
Question, is the hierarchal list a numbered list? If so, the display name should be list formatted to the flat list instead of being formatted as Text. In having it list formatted to the flat list, you can simply do a lookup to the values in the module dimensiionalized by the flat list (1 and -1).
You have to use the lookup and the best way to do it is to use the method I suggested, having the Display Name being list formatted to the Flat list, so we have a built in link. For the summary pieces, you would use the Summary function of Ratio.
From the looks of it, @Artem.shchaulov is attempting to do signage for a Chart of Accounts. I would follow this article and video.