Calculation Help - Is there a function or a way to count number of child of a list member
For eg, if I have State - City Hiearchy
How can I count how many city does a state have using a formula?
@sagarkpr
Yes, there are a couple of ways to do it…If you already have the hierarchy created (Cities rolling up to State), create a line item in a module named Count (formatted as number) and hardcode the formula to 1 with the summary defined as SUM. At the State level, you will have a total.
On the other hand, if you have all Cities and States in the same "flat" list, then in a SYS Module dimensionalized by that flat list, make sure you have a line item named Parent (which is loaded in from an action) and is a list formatted to the flat list, and the line item Count hardcoded to 1. In another module which is dimensionalized by the same Flat list, create a line item name Nbr of Children with the following formula: SYS Flat list.Count[sum:SYS Flat List.Parent]. This assumes your module is named SYS Flat List.
Flat List Module:
Calculation Module:
Got it, This is how I was thinking but wondering if there is a formula I could directly use. Thanks for help
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…