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)

Accepted answers

seymatas1

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

Checks if the value in column F - Attendance is "Meals-Self". (F3="Meals-Self")
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 "Meals-Self", it returns the value in column E.

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

seymatas1

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

All comments

seymatas1

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

Checks if the value in column F - Attendance is "Meals-Self". (F3="Meals-Self")
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 "Meals-Self", it returns the value in column E.

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

seymatas1

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

Quick Links

Can you help?

Unanswered questions

Alternative of Rankcumulate
Is there an alternative to using RANKCUMULATE in Anaplan for cumulative ranking by group? The model's performance is impacted due to the use of rankcumulate. I'm looking for a more efficient approach or best practice to achieve cumulative ranking within groups without degrading performance.
Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.