Hey Anaplanners, can somebody help me how can I get the total numbers of records in a list given that list does not contains top level?
Hi @CommunityMember11, For this You can simply make an Line item Say "Count" then assign a value as 1 in the formula for the same Line item within any module containing the same list without top level as a dimension. After that you simply need to sum up these values which will give you the total records present in list count. For Summing without a Top Level you can refer to the solution given by @AjayM in the mentioned link,
I hope this helps.
@david.savarin shared a great tip in the recent best practices community challenge. It walks through how you can setup a custom list to perform these types of aggregations without adding a top level or enabling summary methods in the module. Check it out!
@seymatas1 @rob_marshall - could you please help with the this requirement ?
@CommunityMember11
Try this out…I usually don't use a "dash", but rather a word like Sum
Can please explain why we create a general list ,a module,and Action ,and what purpose each one serves.🙂
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…