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!
****
Best Answer

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.0218 in the Planual
https://community.anaplan.com/t5/Planual/ctp/Planual
I hope this is clear
David
1
Comments

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
0 
Hi David,
Thanks a lot for the reply.
Can you be a little more specific and give me an example?
Thanks,
****
0