-
Level mismatch in trying to bring data
Hi I have this scenario where I need to bring in data from a source which is dimensionalized by Product L3 (leaf) level and Account to a target which is dimensionalized by Product L3 (leaf) level and Area. Mapping table has Product L1 (Top level of Product) and Account. It has Area as list formatted line item for mapping…
-
Calcuation of subsets as my allocation basis
Hi guys, how can i get the totals of my subsets in my formula so the totals of my denominator will only be the totals of the subsets? Thanks in advance.
-
Max Value for a Line Item on a yearly basis
I am trying to find the max value in a different line item for any given year, all in the same module. time is in months so my start month would be january and end month would be december. so for 2023 I want the max item, for 2024 I want the max item, and so on and so forth.
-
Update Historic Volumes for Baseline Forecast
Hi Im trying to build the volumes for baseline forecast and below is my formula resulting in the following error IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast…
-
Omit the calculate lineitems by using Lineitem subsets
Hi, I want to omit calculate Lineitems by using Lineitem subset. I have these Lineitems. I have to calculate each(A,B,C…) error(= Forecast - Actual) . But in this table , I have to create at least 4Lineitems and input formulas. Category Lineitem Value Forecast A_forecast 100 B_forecast 10 C_forecast 200 ・・・ ALL_forecast…
-
Need help filtering a Module
Hi Community!! I am having issues in one of my Modules and Page, as I need to filter out groupings of Country/Region/Area depending on the Territories the user has assigned. Can anyone provide advise? I have tried with DCA but I cannot seem to get it right. Screenshots attached. Thank you!
-
Level2 Sprint3 3.3.5.3 Check Your Work
Hello all, After inserting the formulas to INV01, my numbers aren't exactly the same as the screenshot on the instruction. Where I might've made mistakes? This is my blueprint view:
-
Joint Deployment Blueprint
Hello, In Anaplan Way training (The Pre-release Phase) the Joint Deployment Blueprint document is referenced, but the link does not work. I also searched but could not find a result. Is this document updated and renamed? Best, Murat Akkas Excerpt : Joint Deployment Blueprint for Anaplan employees and partners–Anaplan and…
-
Mail anaplan report to email as attachment
Hi, Is there any possibility to schedule anaplan report everyday as attachment to user email…
-
Summary settings to Formula Issue
Hi All, I have a module dimensioned with 4 lists, version and time. In one of the line-item I have this formula below, which has a division:- IF ITEM('L2 One-off Components') = 'sys99_Lookups'.Care THEN 'dat20_One-off Credits Actuals'.Revenue / Days in Month ELSE 0 The issue I'm having is that when I go to the summary…
-
How to refer a properties in formulas
Hi, How can we refer properties in formula
-
Level 3 Sprint 2 - 7.3
Hello, All my formulas required for Activity- 7.3,Level 3,Sprint 2 appear to be correct. Kindly confirm the Net Commission formula. As the figures I have arrived differ from the activity screenshot.
-
Better Formula Editor for Anaplan; A Chrome/Firefox/Edge Extension
Hello all! A while back I made a Google Chrome and Firefox extension that enhances Anaplan formula editing by using the Monaco editor (currently 700 users). This is the editor used by Anaplan's new modelling experience. My extension works with this new experience adding enhancements over and above what Anaplan have done.…
-
To Select Q1 (Boolean checked) - From the Input year
Hi All, Need your help! I have an input Line Item Say "A", Year Format. I selected FY23. Now i want only Quarter Q2FY23 to be selected. (Boolean checked). I do not want rest of the quarter to be selected. If the input will be set to FY24 then i want Quarter Q2FY24 to be selected. How this can be achieved? Thanks.
-
1.4.3 Activity - Line Item not showing
Level 2 Sprint 1 - 1.4.3 Activity to create/import SYS12 SKU Details. I created and imported all items successfully, and I can check all records are loaded properly. But by some reasons, I cannot see the last line item, Distribution Center' from the view. What am I doing wrong here, can anyone please help?
-
Schedule vs. Snapshot of Line Items
I have a schedule with two line items below showing exactly how the parenthesis should be. When the snapshot is taken, the parenthesis shows differently (second screenshot). Does anyone have an idea of why there would be a difference in the line items after the snapshot has been taken?
-
How to spread a cost from a father to his son in the hierarchy?
Hi all, I am having a hard time spreading costs along the hierarchy. My hierarchy is composed this way: BU responsible BU R&D project What I am trying to do is to spread a general cost across each BU using a driver and then to spread that BU cost again across its R&D projects using a second driver. The drivers need to be…
-
Regarding 'Applies To' order for Modules
Hi, I had been reading about this article on community. There is a paragraph that says I am looking to understand the reasoning behind this, how it contributes to performance improvement if this order is followed. Regards, Aakash Sachdeva
-
Advice wanted
Hi, I have expense list (5 list items) and one line item (Key fig list formatted).So for each expense list I need to assign one key fig. Suppose for travel expense list item If I have assigned Key fig1 and for the next expense also i have assigned key fig 1 then it should show in blue color indicating that each expense…
-
How to get Previous week vales
HI I want to get prevous year week values . Without hardcoiding means week-52 How can i achevie that Previous year is week format & when ever the 53 week comes that data come that show not go current year 1 st week
-
11.3.2 Activity: Import Data into P&L Actual and Budget
In 11.3.2 Activity: Import Data into P&L Actual and Budget I cannot import any data to the Budget version as it seems like only Forecast and Actuals version exist in the new model I have created. However I cannot tell why the budget version is not there? My systems module for version looks like this: And versions is set to…
-
Level 3 Model Building Sprint 2 Territory Data
Hello, Many of you have probably finished the Level 3 Model Building Certification. As I start Level 3, Sprint 2, I got confused with the below instruction: My questions/clarifications: 1. In Sprint 1, the Level 3 Model is connecting with the Data Hub, and there was an option to download a New Data Hub or Use the Data Hub…
-
Why is my RANK function changing result when I perform Bulk Copy Action?
Hello, In short, when I perform a Bulk Copy, my RANK function is changing and giving different result than what it should be. Detail: I have a raw data source import file that is a listing containing all of our retail locations and their respective royalty rate that they pay us. The majority of the locations have one…
-
Level 1 Model Building - Learner SurveyQuestionnaire
how can i find Level 1 Model Building - Learner SurveyQuestionnaire as i have completed my level 1 exam as my exam status is still not updated
-
Export Subset information
Hi, Is it possible to export details of all the subsets as is possible with the general lists table? Chris
-
Limit on adding cards in Anaplan APPs
Hi Team, Good day! I just would like to check if it's possible to add up to 10 consecutive cards in Apps horizontally as currently, it only allow 6 cards. Any response will be greatly appreciated. Thank you! Rachelle
-
Blank sections in Start Date and Time (UTC)
Why are there blank sections in the Start Date and Time (UTC) column in the actions tab and actions settings? Surely the first time the action was run would log a date and time stamp? If not, then what is the cut off period when this becomes blank? Chris Heathcote www.HeathcoteAndHerran.com
-
How does using a module as a filter works?
Lets see if i can explain my self, I am giving support to a Model which in the UX of the app has filters on top that come from a filter module, they requested me to add a new filter to filter by rep and there is already like 3 filters with that description, but when I add them to the card they don´t work. Filter Module:…
-
Level 1 Lesson 11.3.4 Activity: Add Formulas to Profit and Loss Report Module
Hi I have a problem in fixing the formulas for the above lesson. I have attached the screen shots for the first formula I was supposed to create which is for Headcount. REP03 Profit & Loss Headcount FormulaError message displayed for the formula Further, I would like to know whether the formula repeats itself for all the…
-
Conditional Formatting on "No Data" Format Line Item
Hi all, can conditional formatting be added to a line item formatted as No Data. If possible, please kindly explain. Regards