COUNTA formula in Anaplan

guidopolisena
guidopolisena
in Modeling

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!

****

Tagged:

Best Answer

  • DavidSmith
    DavidSmith
    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.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

Comments

  • DavidSmith
    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
    guidopolisena

    Hi David,

     

    Thanks a lot for the reply.

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

     

    Thanks,

    ****

Categories