Anaplan count function

sanjib

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.

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'.

 

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

 

Thanks in advance

Sanjib

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

sanjib

Thanks a lot,

 

I was able to do the task.

Here is the solution SC-

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.

Thanks in adv

sanjib

Thanks @nikmg

sanjib

Hi @nikmg 

Can you please help me to solve this problem.

I have a module name 'INP-Task'. 

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)

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

INP Task module

 

Thanks