How to get COUNTIF type of formula in Anaplan
I was looking to count a list property text and come up with a numerical value total. In excel we can use countif, what can i use here in Anaplan?
Tagged:
0
Best Answers

I dont know of a simple way, but you can do with a combination of formulas.
In the module that you wish to count, create another line item which will contain an IF THEN ELSE formula. Something like IF NOT(ISBLANK(line item)) THEN 1 ELSE 0 ... or ... IF line item = "xxxx" THEN 0 ELSE 1 ... etc...
Then in the summary module, use a SUM function over the line item created that will "Count" (by summing the 1s and 0s).
Rgds3 
[quote=Dino Sanchez]I was looking to count a list property text and come up with a numerical value total. In excel we can use countif, what can i use here in Anaplan?[/quote]
The method Devin has given is the best way, assuming you want to count any that is not blank.
If instead you wanted to get a count against each different value of the list formatted line item, you could again create two new line items:
First line item: just put '1' in the formula so that every cell contains the value 1.
Second line item: First line item [SUM: list formatted line item] and make sure this is dimensioned by the list that formats the original line item.
Then the second line item will return a count of the number of cells that have each list item.1
Comments

This is also how I work around anaplan without a true COUNTIF() function. Hopefully one gets added to the list of functions soon!1