Help Needed with COUNTIF Equivalent Formula in Anaplan
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)
Best Answer

Here is how I created the same COUNTIF logic in Anaplan:
COUNTIF(Anaplan) line item's formula:
IF 'MealsSelf?' THEN IF 'IFO Name&Transaction Date' THEN 1 ELSE 0 ELSE Attendance Data
0
Answers

=IF(F3="MealsSelf",IF(COUNTIF($O$2:O2,O3)>0,0,1),E3) does the following:
 Checks if the value in column F  Attendance is "MealsSelf". (F3="MealsSelf")
 If true, it counts the occurrences of the concatenated value in column O(Name & Transaction Date) from the start to the current row.
 If this count is greater than 0, it returns 0; otherwise, it returns 1.
 If the value in column F is not "MealsSelf", it returns the value in column E.
It looks like your Excel rows moved up in the screenshot you provided.
0