IF statement with different hierarchies

Below, I have this module dimensioned by O2 Department (Level 2 in the hierarchy) and another list. My IF statement always returns FALSE when I have some start dates that do match the first day of the month. DAT03 New Hire Details is dimensioned by New Hires (Level 4 in the hierarchy). I believe I have a hierarchy issue somewhere. Any ideas on how to get this formula to work and return TRUE when it's supposed to?

Accepted answers

All comments

ManjunathKN

Hi @BryanByrnes ,

If I got your problem statement correct, Dat04 is having a parent hierarchy so, you should do a SUM of parent.
but, before to that you are also referring a date logic from Dat03 to Dat04 (from L2 to L4).

So here is how I would solve,

I would create 2 Line items in Dat03
-->LI 1 - Start(period(Start Date)) = Sys02.first day of month - Boolean formatted - Summary none
-->LI2 - if LI 1 then 1 else 0 - Number formatted - summary sum

Now in Dat04 I would create 1 more line item,
--->LI 1 - Parent(parent(L2)) - List formatted (L2)
--->Total Future Hires - IF Dat03.LI2[sum: Dat04.LI1]>0 then Dat03.New hires[sum: Dat03.Department, Sum: Dat03.Pay type, Sum: Dat04.LI1] else 0

Thanks,
Manjunath

BryanByrnes

Thanks for the quick response. DAT03 doesn't have time as a dimension so LI1 is never true.

ManjunathKN

@BryanByrnes ,

Correct, I missed that. basically what you can do is to create a staging module for Dat03 for only that start date Line item along with time and use this line item instead of LI 1 boolean formatted in Dat03.

Thanks,
Manjunath

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…