Help Needed with COUNTIF Equivalent Formula in Anaplan

SUMAN GANGADAR
SUMAN GANGADAR
in Modeling

Hi Anaplanners,

I have a doubt about Anaplan. I know it's a silly question, but I'm not able to solve it in Anaplan. If anyone has an idea, please explain it to me.

I have attached a screenshot to this post for reference.

Problem:In Excel, please refer to the N column, which is already highlighted. They are using the COUNTIF function in Excel, and data is populating based on the formula. I want to perform the same activity in Anaplan, but I don't know how to write the formula in Anaplan. If anyone has an idea, please explain it to me.

FYI:

  • NAME & Transaction Date: General Format
  • Transaction Date: Custom (mmmm d, yyyy)
    SCN-1.png
    SCN-2.png

Tagged:

Best Answers

  • seymatas1
    seymatas1
    edited July 23 Answer ✓

    =IF(F3="Meals-Self",IF(COUNTIF($O$2:O2,O3)>0,0,1),E3) does the following:

    1. Checks if the value in column F - Attendance is "Meals-Self". (F3="Meals-Self")
    2. If true, it counts the occurrences of the concatenated value in column O(Name & Transaction Date) from the start to the current row.
    3. If this count is greater than 0, it returns 0; otherwise, it returns 1.
    4. If the value in column F is not "Meals-Self", it returns the value in column E.

    It looks like your Excel rows moved up in the screenshot you provided.

    image.png


  • seymatas1
    seymatas1
    Answer ✓

    Here is how I created the same COUNTIF logic in Anaplan:

    COUNTIF(Anaplan) line item's formula:

    IF 'Meals-Self?' THEN IF 'IFO Name&Transaction Date' THEN 1 ELSE 0 ELSE Attendance Data

    image.png
    image.png

Categories