-
Transportation Planning
Hi, I am looking for a standard demo or Model for transportation planning published by Anaplan which is accesible to all. Thanks and regards Ruchir
-
How to aggregate of data with different dimensions across modules.
Hi everyone. I have two modules. Each module has different dimensions. And I would like to aggregate these modules to one modules. Please see below: I assume that it will be solved by importing data between modules. But I don't know the specific solution. How can I solve the problem? Best regards, Taku
-
Version Budget formula
Hi The Current Fiscal Year is Jan 2020 to Dec 2020 No of Past Years : 1 No of Future Years: 1 Current Period: changes monthly For a Sys module, what formula (Boolean type) can be used to select the months for Jan 2020 to Dec 2020 (even though Current Period changes)?
-
Module line item formula not working
Hi I am trying a simple formula to populate the line item 'Destination Org (Source)' in my module 'Comp Incoming PR/PO'. The formula is comp_pro_po_supply.Destination Org. Any help is appreciated. Thanks Regards Prabakaran
-
Planual Explained - Day 17
Below rule is connected to the rule explained in Planual Explained - Day 16 - Anaplan Community Go through it before you read further. "Rule 2.02-05": Article 2, Chapter 2, and Rule 5 – “Create “joins” in smallest hierarchy”. “If a text string join is needed, create the joins in the smaller hierarchies first to minimise…
-
Item name must be mapped-error message
Hi I have the list comp_pr_po_supply and trying to import data from the datafile in my computer. During mapping, I am getting the message ,Item Name must be mapped for the property comp_pro_po_supply. I assume I am getting this message because comp_pr_po_supply has been setup as a list item. But, I don't find that in my…
-
Planual Explained - Day 16
"Rule 2.02-04": Article 2, Chapter 2, and Rule 4 – “Text Strings”. “Treat text strings with caution. Try and avoid multiple joins and split common joins to separate line items”. It goes against PERFORMANCE, LOGICAL, NECESSARY elements of PLANS if you wish to go against this rule Here is how it was done in Pre Planual Era:…
-
Product Allocation in Anaplan
Hi Team, I want to understand how Product allocation happens in Anaplan. Lets say, I have P1, P2, P3 upto P10 products under a Parent called PRC1. Now I have some amount at P5, while allocating this P5 amount has to be taken to its immediate parent which is PRC1 and it PRC1 has to allocate this amount to all of its Lev0…
-
Referencing Line Item data (from module) to a general List in another module
Hello members, Seeking a quick help from all. I have a list 'Roles' which is being used to define different categories of roles in an organization (refer attachment 1. List - Roles). In module 'Employee HC L1 (Actual+Forecast)', calculation for headcount is being done for each of these roles. However, the dimension in this…
-
Group by/sum alongside multiple attributes
Hello Community, I'm facing the below problem (probably there is an easy solution, however I'm too much immersed into it that prevents me to find it). 🙂 I have an excel database where I have several attributes and a value in the columns. I created a unique key manually in order to upload it into Anaplan. So now I have in…
-
Finditem formula invalid
Hi I am trying to use the FINDITEM formula for one of the line item in my module. Following is the formula used: Organization Code LF = FINDITEM(OPSdb Site, Organization Code LF). Please refer the screenshots attached. Any help would be appreciated. Thanks Prabakaran
-
Business Units in Finance
Hello! I hope you are great! I need your help with some tips: We have multiple business units (BU), some with specifics characteristics and others with similars and we need to consolidate the financial results of all company. Also we analyze the relationship between financials results and KPIs. What is the best practice?…
-
Aggregation of Text Comments up a hierarchy using TEXTLIST
End goal is to be able to enter and aggregate text formatted comments up a hierarchy. Entry should be possible at each level, with prior results appended. I feel like I should be able to use TEXTLIST in the Summary: Formula for the line item and have it roll up the hierarchy on its own. I have not been able to figure out…
-
Circular Reference - IRR
Hi All, I've encountered Circular Reference in a calculation that involves IRR formula, for which I think is an illogical treatment of Anaplan. Please could you give some advice: The calculation is as following: Relation 1: Operating Results (ORt) = Operating Income (OIt) x Adjustment Factor (AFt) Relation 2: Adjustment…
-
Module Line item
Hi Would appreciate any help here I have a module ' Comp Reservation Details' which is mapped to the list 'comp_reservation_details'. I have entered the formula for the module line item 'Reservation ID' as ' comp_reservation_details.Reservation ID'. The values are getting populated in the column 'Reservation ID' as…
-
Conditional Formatting For Versions
Hey , I want to apply Conditional Formatting for one of the Version that is Variance not for line item so is it possible in anaplan ?? because we have only experienced to apply conditional Formatting on Line Items based on Values.
-
Change structure List
Hi Teams, I have data using List L3 but in next month(Feb 20) the structure will be change, but structure and data in previous month(Jan 20) not impact, like a picture bellow can we do that in anapan? Thank, Panji
-
Line Item Switchover - Formula Error
Hi Team, I'm receiving a Formula error when I turn off the Switchover on a particular line item & I can't understand what is driving the error The error occurs when I turn the Switchover to FALSE in the Calculation image below Any ideas what would be driving this? Error Calculation Reference 1 Reference 2
-
Missed the Anaplan Live!: Anaplan Helps Q&A?
Did you miss our first Anaplan Live! Spotlight event? The recording of the live discussion is posted here! In the live event, our presenters discussed all things Anaplan Helps! Watch the video to learn how the program is helping support customers during this challenging time and hear from MAs about the applications they…
-
How to use SUM function between modules
Hi everyone. I have a simple question. I would like to calculate the total cost of staff from a module that inputs the cost of staff for each month. Please see belows... How can I solve it? I don't know better idea... Best regards. Taku
-
Level 2
Hi, why my line chart on Dem 03 shows Baseline Forecast and Initial Demand Forecast for one year. I have used the formula for Baseline Forecast: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Default Forecast, -52, 0)
-
Formula Inquiry
Hi Guys, I just want to ask something. Our client has an excel report template, its more like Operating Statistics type of report. It basically counts values per month and it is usually referenced to another cell in their report. After checking the issue sent to us I notice one 1 line item (actually it is an entire year)…
-
Bring weekly data into a daily module
this should be easy but I just can't get it. I have a weekly module with inventory cases...snapshot is done on Wednesdays. Anyway trying to take that snapshot and have it show up in a daily module on the Wednesday date. Any help would be greatly appreciated. I'm trying to avoid making the inventory cases a daily module.…
-
Planual Explained - Day 15
"Rule 2.02-03": Article 2, Chapter 2, and Rule 3 – “No Repeated Expressions”. “If the expression is repeated in the formula (or other modules), put it on a separate line item. Calculate once, reference many times. It goes against PERFORMANCE, NECESSARY elements of PLANS if you wish to go against this rule Here is how it…
-
How to Apply Time Filter to graphs?
How can we apply Time filters to graphs?
-
Level 2 Model Building Sprint 3 INV04
Hi, Could someone please help me with the module below? I am struggling with the Percentage Full result that I get and I think it is because I am doing something wrong in the Beginning Inventory line. I am pulling BI from DAT01 which gives a straight line across all months. What am I doing wrong? I also could use a…
-
Error in Importing
Hi, guys! I always have this problem when I am importing my data in Anaplan. I tried all the methods I know but I can't solve this problem. I am trying to upload this data to my budget version but to no avail. Hope you can give some assistance! Thank you for the help!
-
How to implement "hardcoded" logic with best practice in following example
Hi, I have the following challenge in modeling the target module. I need to aggregate data before calculation to account level 1, but there is an exception for certain accounts where I need to aggregate those for level 2. I have tried to create system account details where I flag those accounts which are exceptional…
-
How to rename the Time from Week 1 FY 20 1-Jan-2020 to 7-jan-2020
Hi Guys, Is there a possibility to rename the TimeScale from Week1 Fy20 to 1-Jan-2020 to 7-Jan-2020 Thanks and regards PJ
-
Planual Explained - Day 14
"Rule 2.01-15": Article 2, Chapter 1, and Rule 15 – “Filters in separate modules”. ” Try and keep filters in separate System modules. They can then be reused for different modules. In the notes section list where this filter is used to prevent accidental deletion”. It goes against Auditable & Necessary elements of PLANS if…