Hi Anaplan community, I am facing a problem and need help. I created a line item (Active?) to define whether the employee is active or not. The formula that I used is: IF PERIOD('DAT04 Employee Data'.…
I am having an issue where only 1 cell does not match how my model is supposed to look like. It seems like "Utilities" (and subsequent line items that use utilities as part of its formula) is the only…
Hello! I am looking to create sequential numbering on employee numbered list within their respective cost centers but also looking to skip certain criteria such as TBHs. I am currently using RANK(1, A…
Hello All, I am having trouble extracting certain parts from the code like 217_2021_2_2021_3_1_56, that first three digits is the phase code, then year, then month, then another year, another month, v…
I'm fairly new to Anaplan and I'm sure if I'm approaching this issue correctly so I thought I'd ask here. We have sales rep data that shows what "compensation group" they belong to for a specific mont…
Hi, I would like to know if the way I'm calculating the distribution factor is correct? The only problem I believe would be the denominator, because I only want the product values and not the product …
Hi, I have been stuck on this problem for quit sometime now. I know my formula is correct and my dimensions of mapping between my modules are correct, so I do not understand why I'm still getting a di…
Hi, Would like to know if my DAT02 Formula and Dim are correct. I'm not able to LOOKUP or SUM in Country and P1 Product Family into my TAR01 Module and it is saying because Dimensionality. Below is a …
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for …
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for …
Hi, I'm having trouble with putting together the TAR01 Module. I understand the task is to get the Total Revenues of my Products (P1 List) by Country and it's "Children" (G2 List), and then fine the p…
Hi Everyone, I’m trying to do something really simple but failing. I’ve got a list of loans and each loan has a starting date. Interest is payable every x months from the starting date. I want to crea…
Hi, My question is There is a Function in Excel and there is no similar kind for function in Anaplan, so how to in cooperate that function in Anaplan Regards Surya
Hi - I am trying to bring in Region and Role. I added them as a line item in my module: Here are all the modules: And here are my lists: Can anyone help me with how to write a formula to bring in Regi…
Hi everyone, I am on L2 Conclusion chapter. I have created the formula to populate Shipping cost. Please see below formula . As long as I understand the formula is correct but the aggregation i am get…
Hi Can someone help me where do we find LIS REP03 P&L:Items while creating a REP05 module. I couldn't find it in lists and roll ups columns even though I have created line item subset.
Sometimes in the numeric formatted cells, as a result of various calculations, it is possible to have returned as a result the Anaplan special numbers: Infinity, -Infinity, or NaN (Not a Number). If t…
I need to convert the text formatted data below to the date format 03/08/2022. I have a formula to do that, but the time stamp on the right interferes with my formula. How would I remove that part of …
The NAME function always returns the #ID and not the display name. I need another function that could returns the display name. If this function doesn’t exist, I’m looking for a solution to switch fr…
I have a boolean that allows users to select if they would like to add a price adjustment by years. If a user selects that they would like a price adjustment then it should apply to all months within …
Hi Team, I hope you can help me with a step I am struggling with. I have Module that have 4 years "Raw Data - Module: Data 00 - All T&E" for Transaction detail (using an Index as a list) and it has ma…
Hi All, I have 2 modules, Module 1- Dimensions - Entity, Custom Version, Time Period, Department Line Item - A,B,C Module 2- Dimensions - Custom Version Line Items as Follows: When i apply this filter…
Hi All. I'm facing an issue in solving the Opening Base Calculation. Please help to resolve it!!! Custom Versions - Actual, Estimate,Budget Time Period (in Months) Country List Department List GL Acco…
Hi all, Could you please explain when to use Lookup or SUM function, I remember there was a lesson in MB Level 1 course but I am unable to find it. I will really appreciate if someone can provide a li…
Hi, I'm having alot of trouble with the LOOKUP formulas for this module. I'm trying to bring in my DAT01 Actuals into the TAR01 Module by Country and it is not working. My dimensionalities are correct…
Hi All, I'm new to AP and I have a question..... I have a module that has Employee, Product Line and time as the dimension. My question is how do I tell Anaplan to group by certain products only? ie. …
I have 3 level hierarchy Namely --- Country > State > District State and District has line items as properties namely Active in Boolean format i want to connect the two by using formula like if parent…
