Hello,
I am trying to count how many items are in a list and display it in a module?
In the example below we have 3 items in the list.
Does a function like this exist?
Create a system module (with #promotion flat as a dimension) with a line item called "count" and a formula of just "1". Create a second module which is a "totals module" (without #promotion flat as a dimension). In the totals module create a line item called count that directly references the system module (system module.count). It should naturally grab the top level.
Thanks! That worked. I was overthinking it.
if the flat list don't have top level item, how it will calculate?
hey @Javvaji45 , if you see at the screenshot there is top level item present.
Note: flat list cannot be a part of hierarchy.
Thanks.
I got the solution for the with out top level item , we can calculate the count of items in flat list , by using the Another dimension based on the dimension we can calculate it .
Hi @Javvaji45 can you explain how to calculate count of items in flat list without top level
@SyedArbaz create one more list and add the item like "Top level" , you can hard code this item in the flat list dimensioned module and write the sum formula in the target module. see the below screen shots
Thank you @Javvaji45 it worked :)
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…