Count the number of users using User list for every months.

Hi All,

I would like to take a count of the users using the list Users for every month.

I have a module with:
Row: Users List
Column: Time(Month)
Line item : Number(whose formula is 1)

I need to sum the number all all the users for a particular month for eg for Jan sum of users can be 74.

Count_2_142407.JPG

Count_-_1_142407.JPG

Accepted answers

JaredDolich

@tinathom

So transactions would look like this. Just add a counter (formula). Your transaction list should be parsed with FINDITEM. To expedite the example, I just used User 1, user 2, etc..

The planning module will be months only. Then a line item 'DAT01 Active Users'.Counter[SUM: 'DAT01 Active Users'.Month Active]

All comments

JaredDolich

@tinathom

I think I'm following your use case but might be off a bit. It seems you're trying to count the users that were actively training at a given month. Is that right? If so, I would suggest a slightly different approach to getting the counts you're looking for. We'll follow the DISCO methodology.

For your DAT module make sure one of the columns identifies the user and the month they were active.
Create a SYS module using months and a counter that equals "1"
Create a Planning module, or in this case, an output/reporting module that uses months and Users.
Create a line item that uses the SUM function on your counter in your month SYS module for each user.

tinathom

Thank you for your reply but the list I used is Users list. I have to use Users list because it gets updated on its own when I provide access for a customer.Every month we take a count of how many customers got added into Anaplan model. So it would be helpful if I get a formula to do a sum. What I tried to do was module A.count[sum : Module B.time ] but I suppose this doesn't work for Users list since Users list has no top level.
Please help.

JaredDolich

@tinathom

So transactions would look like this. Just add a counter (formula). Your transaction list should be parsed with FINDITEM. To expedite the example, I just used User 1, user 2, etc..

The planning module will be months only. Then a line item 'DAT01 Active Users'.Counter[SUM: 'DAT01 Active Users'.Month Active]

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
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.…