Anaplan count function

Hello Anaplan Community,

I am stuck in counting the items in a line item.

I have a line item called 'Status' and it is List formatted.

Screenshot (57).png Screenshot (54).png Screenshot (55).png

Now I want to count the number of Particular items in the line items. Like 'Completed' occurs four times, so it should count completed as 4.Like wise 'In Progress' occurred four times, so it should give me count of 4.

All the count I need in a separate module called 'Count of Status'.

Screenshot (56).png

How can I proceed? Please help me with the formula or way to do this task.

Thanks in advance

Sanjib

Accepted answers

nikmg

Hello,

You can use the SUM function to execute this.

1. Create a Count line item [number formatted] in the "Inp - Task 1" module.

2. Hardcode the formula "1".

3. In the "Count of Status" module, write this formula: Inp - Task 1.Count[Sum: Inp - Task 1.Status].

Ex:

nikmg

HI @sanjib ,

You will just need to append another sum over the "Owner" column to the same formula.

Your new formula would be Inp - Task 1.Count[SUM: Inp - Task 1.Status, SUM:Inp - Task 1.Owner].

Best,

Nik

All comments

nikmg

Hello,

You can use the SUM function to execute this.

1. Create a Count line item [number formatted] in the "Inp - Task 1" module.

2. Hardcode the formula "1".

3. In the "Count of Status" module, write this formula: Inp - Task 1.Count[Sum: Inp - Task 1.Status].

Ex:

sanjib

Thanks a lot,

I was able to do the task.

Here is the solution SC-

Screenshot (61).png

Now I need another help.

In 'Inp-Task 1' module, I have a line item "Owner-(List formatted).

I need to count the Status according to Owner. Like Sanjib has one Reopen Status and one In Progress Status. So in the new module "Count of Status by Team Mate", it should show me the count as Reopen 1 and In Progress 1 and other task 0. Like wise for other owner also.

Screenshot (64).png

Thanks in adv

nikmg

HI @sanjib ,

You will just need to append another sum over the "Owner" column to the same formula.

Your new formula would be Inp - Task 1.Count[SUM: Inp - Task 1.Status, SUM:Inp - Task 1.Owner].

Best,

Nik

sanjib

Thanks @nikmg

sanjib

Hi @nikmg

Can you please help me to solve this problem.

I have a module name 'INP-Task'.

Screenshot (72).png

I have another module name 'Out- Task', in where the only task associated to user should be shown.(I have given selective access to user list)

Screenshot (74).png

Like Sanjib is the owner of TAS08 in 'INP-Task', so in 'Out-Task', only 'TAS08' should be shown.

Hope you understand my problem.

Thanks

nikmg

HI @sanjib ,

I would recommend creating a separate post for different topics as it helps people filter and find them easily.

Now about the issue at hand, you could use the function TEXTLIST, but that is a highly performance inhibitive function and its usage is against Anaplan best practices.

An alternative that @rob_marshall has recommended in the past is to utilize Booleans and ANY function to achieve similar results.

Here is how you can implement it:

In your INP-Task module, create a Boolean flag as below [Formula =TRUE]

Now create a mapping module dimensioned by both the Users list and the Tasks list. Fetch this Boolean flag into this new mapping module via ANY function.

In the same mapping module, create another line item [Format: Tasks List] and write a formulas to get the task names for relevant intersections. Summary of this line item should be either firstnonblank or lastnonblank, both works. See blueprint view of the mapping module below

Finally, in your 'Out-Task' module, you can directly reference the 'Get Task Name' line item from the mapping module. You have your result as below.

Hope that helps!

Best,

Nikhil

sanjib

Hello @nikmg

Thanks for your help, I was able to do that.

Now I want to insert the line item information of 'INP-Task' like Backup, Priority, Start Date, End Date, Due Date associated with the user task in the module 'Your Task'.

Your Task Module

Your Task Module Blueprint view

Screenshot (78).png

INP Task module

Screenshot (77).png

Thanks

Quick Links

Can you help?

Unanswered questions

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…