Formula help on counting a Text LI

Hi,

Need help on how to count the number of times a Text dimension LI shows up under a List LI. We have tried to use the SUM function as well as LOOKUP function, but they did not work. For Ex) We would want to know how many "Merchant Id's" are under each individual 'Legal Milestone" Below are snap shots of the two line items and modules we are trying to complete this in.

The Formulas we have tried are below:

Merchant ID[SUM:Legal Milestone]

Merchant ID[LOOKUP:Legal Milestone]

Accepted answers

All comments

JaredDolich

@neg177

System modules!

You can create a line item in your D01 Legal Milestone module. Call it Counter =1. This is a good exception for a subsidiary view if you have other lists in this module.

Since you already have a module that contains the relationship between Merchant ID and Legal Milestone (D01), you can add a line item in your Legal Milestone system module Call it Merchant Count = D01 Legal Data.Counter[SUM: D01 Legal Data.Milestone]

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
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.…