COUNTA formula in Anaplan

Hi,

I was wondering if there is in Anaplan the equivalent of the "COUNTIF" Excel formula: basically counting the cells in that range that match a specific condition. I was thinking of using it for calculating the % of Cost Centres that have input data so far against the one that have no values.

Many thanks in advance!

****

Accepted answers

DavidSmith

As shown below

Now this is a very simple example, and if it is a simple as this, then there is no need to split the condition into a separate line, but if the condition starts getting complex, it is better to split it up as per 2.02-18 in the Planual

https://community.anaplan.com/t5/Planual/ct-p/Planual

I hope this is clear

David

All comments

DavidSmith

Unfortunately not

You will need two line items:

One for calculate the condition

One to hold the value for the TRUE state (IF condition THEN value else 0)

David

guidopolisena

Hi David,

Thanks a lot for the reply.

Can you be a little more specific and give me an example?

Thanks,

****

DavidSmith

As shown below

https://community.anaplan.com/t5/Planual/ct-p/Planual

I hope this is clear

David

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled