New Contributor

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!

Guido

3 REPLIES 3
Community Boss

Re: COUNTA formula in Anaplan

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

New Contributor

Re: COUNTA formula in Anaplan

Hi David,

 

Thanks a lot for the reply.

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

 

Thanks,

Guido

Community Boss

Re: COUNTA formula in Anaplan

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

 

2019-06-27_09-51-07.png

 

I hope this is clear

David