topic RE: How to get COUNTIF type of formula in Anaplan in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/How-to-get-COUNTIF-type-of-formula-in-Anaplan/m-p/815#M2950
[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 '<B>1</B>' in the formula so that every cell contains the value 1.
Second line item: <B>First line item [SUM: list formatted line item]</B> 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.Thu, 14 Jan 2016 19:17:15 GMTPrevContributor2016-01-14T19:17:15ZHow to get COUNTIF type of formula in Anaplan
https://community.anaplan.com/t5/Anaplan-Platform/How-to-get-COUNTIF-type-of-formula-in-Anaplan/m-p/813#M2948
<P>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?</P>Tue, 30 Oct 2018 21:11:51 GMThttps://community.anaplan.com/t5/Anaplan-Platform/How-to-get-COUNTIF-type-of-formula-in-Anaplan/m-p/813#M2948dino_sanchez2018-10-30T21:11:51ZRE: How to get COUNTIF type of formula in Anaplan
https://community.anaplan.com/t5/Anaplan-Platform/How-to-get-COUNTIF-type-of-formula-in-Anaplan/m-p/814#M2949
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).
RgdsWed, 16 Dec 2015 12:49:14 GMThttps://community.anaplan.com/t5/Anaplan-Platform/How-to-get-COUNTIF-type-of-formula-in-Anaplan/m-p/814#M2949PrevContributor2015-12-16T12:49:14ZRE: How to get COUNTIF type of formula in Anaplan
https://community.anaplan.com/t5/Anaplan-Platform/How-to-get-COUNTIF-type-of-formula-in-Anaplan/m-p/815#M2950
[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 '<B>1</B>' in the formula so that every cell contains the value 1.
Second line item: <B>First line item [SUM: list formatted line item]</B> 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.Thu, 14 Jan 2016 19:17:15 GMThttps://community.anaplan.com/t5/Anaplan-Platform/How-to-get-COUNTIF-type-of-formula-in-Anaplan/m-p/815#M2950PrevContributor2016-01-14T19:17:15ZRE: How to get COUNTIF type of formula in Anaplan
https://community.anaplan.com/t5/Anaplan-Platform/How-to-get-COUNTIF-type-of-formula-in-Anaplan/m-p/816#M2951
This is also how I work around anaplan without a true COUNTIF() function. Hopefully one gets added to the list of functions soon!Tue, 16 Feb 2016 00:17:20 GMThttps://community.anaplan.com/t5/Anaplan-Platform/How-to-get-COUNTIF-type-of-formula-in-Anaplan/m-p/816#M2951kaitlyn.kisiday2016-02-16T00:17:20Z