-
Filter
How to apply filter on line items? There are 4 line items Baseline Forecast,Growth Rate %,Default Forecast,Initial Demand Forecast. I want just 2 line items Baseline Forecast, initial demand forecast. The chart should show the monthly Baseline Forecast and Initial Demand Forecast for two years. so I want to filter time on…
-
how to write if column (a list) contains x then 1 else 0
Hi there - am new to anaplan have only used excel extensively. I need to add a conditional colum (col 2)n based on another column (col1) which is a list type. That is if col1 contains "x1" or "x2" then 1 else 0. Thank you
-
Interesting Build request: other methods?
I had a scenario posed to me and took a stab at building it. I would love to get any feedback or alternate methods of tackling this. Scenario: * Your user will be entering two number inputs * These inputs will be in a module that has Months * The user wants to see the numbers that they would need, month by month, to move…
-
L2 Sprint 2 2.4.7 Grid UX saved view not matching
Hi All, The activity 2.4.7 instructs to make a saved view as this: But What I've got is like this: Is there a way that I missed that enables me to compare 2 line items for a certain period of time?
-
immport error
Import ErrorI will get the below error 9.1 Import Historic VolumesModel object "'DAT03 Historic Volumes'.Export" could not be located* 9.2 Import Opening Stock * 9.3 Import Shipping Metrics
-
Import Error
I will get the below error 9.1 Import Historic VolumesModel object "'DAT03 Historic Volumes'.Export" could not be located* 9.2 Import Opening Stock * 9.3 Import Shipping Metrics
-
Formula
Add a formula to the Growth % line item to convert the DEM01 Volume Growth Rates.Growth % (monthly) value to weeks. WEEKVALUE() is used, but didn't understood.
-
Anaplan model builder certificate
Hi All, I have completed my level 1 and level 2 model building exams including the conclusion. I printed the level 2 model building certificate. However I haven't yet received the anaplan model builder certificate. It's been 2 days since I completed the course. I also emailed academy@anaplan.com but haven't received any…
-
Model Versions Lookup
Hi, I have a source model in which the model versions(default versions) product list and time as a dimensions. There is an version selection module where the user can select the base and target version for dynamic variance calculation. The target module has Product and time dimension. I need the value of the External Base…
-
Line item style setting
Hello all, This might be an easy one: How should I change the line item style? I'm trying to make mine like below:
-
Mapping
I am facing problem with mapping. In sheet 20 jan month name, in grid view jan 20, so facing problem with time mappaing.
-
Formula for a Module
Hello everyone! I'm having a problem, I need to populate this Boolean line item (circled with green) on this module with the data on the list subset. But I can't select the list subset in the formula bar. Thank you!
-
How to do month to date(MTD) calculation in a module
How to do month to date(MTD) calculation in a module
-
Centralized Identity Management (CIM) - Huge Step Forward
By the end of this month CIM will be rolled out - What does that mean for all of us? I personally feel this is a huge step forward as an additional security measure. * Workspace admins will no longer be able to add or remove users from the "Users" section of Models. * Workspace admins will only be able to assign Model…
-
Conditional Formatting issue
Hi, Can I ask for help on the conditional formatting part. I have an input template where once the user inputted more than a hundred percent the cells should turn red stating that this is the maximum percentage they can enter. I created a rule (see below) but it seems to be not working.See below Both row and column are…
-
Sorting
I want to sort a list which is pulled in a module in rows(Pivot). Whereas, When I try to apply sort it is sorting based on line items(i.e Amount) Is there a way to sort this list ?
-
Limitation on Input Values
Hi, I have a question which might be fairly simple to some of you. So I have this Input template where Users need to input values in terms of percentage. But the Users preferred to limit the amount to only 100%. See below so as you can see on the screen shot provided. under the column Percentage % I was able to input both…
-
1.5.6.1 Create Historic Volumes Module - Mapping Help
Hello - I am having trouble with mapping. I seem to have everything right except time. Can someone point me in the right direction?
-
Logic to Solve different companies mapping to SKU as input
Hello All, I'm trying to solve the below logic but unable to; need your help on the same; The below module applies to the list SKU. and maps to the company which is applicable based on the boolean. I have input data sales price by SKU and by month and by all the company Now, I would like to get the sales price by SKU by…
-
Invalid Formula: Line Item not recognized as Line Item or List Member Error
Hi everyone, I am working through a Territory Model project and came across a really weird issue and I was wondering if anyone else in the community has a reason for why the error message came up. In the calculation itself, I am using a lookup function to bring in data from a calculation module to a data module but for…
-
Beginning Inventory is not fetching the data properly
please see the attached modules to match the formula i adopt
-
NPV and Amortisation
Hi Guys I am running into a problem using the NPV calculation and a subsequent amortization calculation. Please see attached: I used the NPV formula to calculate the NPV of a 12 month variable cash flows. This is equal to the opening balance of a liability. 213,473) When i develop an amortization schedule including…
-
Percent Growth Formula Logic
Hello, everyone, I'm trying to put together the formula to display the appropriate Unit Increase by & Total Unit Value outputs in the table above. The logic should go thus: The 2% growth for FY23 should use the 100 unit value from FY22 as its base. The formula would go thus: (2% of 100) The 5% growth for FY24 should use…
-
Daisy Chaining versus Avoiding Duplicate Formulas?
Hi All, I have a question about daisy chaining versus not repeating a formula. From what I understand, the engine will calculate the below module faster if I didn't reference Division and Deal Size in the Selected line item. Line itemSelectedDivisionDeal SizeFormula(ISBLANK(Division) OR FilterSelections.Division =…
-
Stuck on L1 Training 7.2.1
For some reason, I cannot get the import right. I'm finding the import settings not very clear. I've attached some images of what I am trying to do, but also included from the course what it is supposed to look like. Any help would be appreciated!
-
Level 2 Sprint 3
I'm not getting any errors at the time of export but can't see any data. Please help
-
Level 2 Completion
I have completed and passed all the 4 exams of Level 2 and have submitted the model history as well to be graded. Request to please let me know what are next steps i need to do to get the certification and have the Anaplan Certified Model Builder certificate Regard Shashank Gupta
-
Deleting "unwanted" promotions
Hello Experts, I am encountering issues when rolled over financial year into new one. It looks like the old promotions even thought they were marked for deletion in the "Conditional Investment" tab, they are still in MAS48 modul and causing problems and doubling up the promotions and investments in Profit and Loss…
-
Access to Anaplan Workspace
I am a student. Need access to Anaplan workspace to complete Model building courses.
-
3.3.7 Activity: Add DCA to Inventory Ordering
Hi Anaplan Moderators, Can someone help me out! to check if my formula and the results is right or wrong. Thank you The pics below is the results and the formula: