-
Level 1 Model Building Activity 5/6. Super Stuck - Need Help
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 1.5 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
Formula Help
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 create a Boolean every x months from the starting date. How do I do this? I can put a boolean in the first repayment date but…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Please suggest the process to avoid the errors...see the screenshot attached.
-
Another row has already been processed with this key
Is there any way to suppress messages after importing into a List that are a result of the 'Another row has already been processed with this key'
-
Rgarding the anaplan workapce models
Im done with the level1, level 2 sprint1,2, and 3 including conclusion also and left with the updating the history of level2 supply chain but in my workspace ,my models are not showing the models and states no model yet.... can anyone suggest what to do now...Hereby i'm attaching the screenshot also... Thank you...
-
Using Excel function in Anaplan
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
-
SYS08 Region and Role
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 Region and Role?
-
L2 Conclusion - Create Shipping Export Module -
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 getting is not correct. 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] Plesase…
-
REP05 Local Currency P&L
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.
-
Deleted model
Hi, I have 2 questions: -I accidentally deleted the model i worked on during the course for level 1. Do i need this model for the exam? -When i try to start over the course from scratch for practice purposes, the model I download from chapter 1 already contains data? Can someone help please. Thanks, Jacob
-
UNDO Action
What are the ways to implement "UNDO" action/process with a help of a custom created button on dashboard in Anaplan? This UNDO button would reset values of cells to it's original initial value.
-
Date Conversion
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 cell? Or how would I add it to my formula: DATE(VALUE(RIGHT(As Of Date, 4)), VALUE(CODE(FINDITEM(Time Conversion, MID(As…
-
Use formula « NAME » for a Number list
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 from a list format to a text format. So I’ll be able to concatenate. The difficulty is: the format list used is different from…
-
How to cascade a year boolean into months?
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 that year. I have another module by month where if a user selected to add the price adj boolean for the year from the…
-
Implement Start and End
Hi I have a config module(Config Module1) that contains key-value pairs with start and end dates. For example customer_id (format = text) customer_name (format = list formula = finditem(list1, customer_id)) keyvaluestartend1cust1categoryc1March 01, 2022March 05, 20221cust1categoryc2March 06, 2022 2cust2categoryc1March 01,…
-
I want to remove the time dimension in my system module. What should I do?
Hey guys, I am new to Anaplan. In the level 6 of the model builder 1 course, I accidently added time in my system module. I later realize that in level 8 that I was not supposed to do that. I know that we can change dimension in Applied To column, but what about the Time dimension? Can I remove it somehow?
-
Creating a Module Report but need to bring detail
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 many items such as Vendor, Periods, BU, Functions, Account #. And as I need it for reporting purposes, I have bring the Lists…
-
Don't Use Show/Hide on Production List
DON’T USE SHOW/HIDE FEATURE ON PRODUCTION LISTS We recently had faced an issue – On the dashboard there was one production list (Let’s say P1) as one of the dimension of a module. We had created a saved view by using Show feature on P1 page selector because we wanted to show only a few list items to the end user and not…
-
Filter Issue
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 in source module (module 1) , It still shows me the estimate and budget. which i wanted to hide. (Jan 22, Feb 22 for…
-
Need solution
Hi Team, Please can you suggest how to get the values for "Shipping Costs" in my activity it is showing "0". But as for the formula 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] - In INV01 Shipping Costs values "0". "
-
How to Use Below Functionalities
There are certain functionalities which you might have ignored, seldom used or don’t know if they are available in Anaplan. Here are a few functionalities, their location in the model and the usage of these. Hope you make best use of these functionalities. Brought-Forward: You can see this functionality in the blueprint…
-
Circular Reference Error While Calculating Opening Base with Custom version
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 Accounts In the below screenshot, closing base is the sum of Opening Base,Gross Activation and Churn Rate. When i try to…
-
format of mapping used for lookup doesn't match any dimension of the source
Team, I have one System Module and other Exp drivers module. Created a new module and adding formula to get the expenses numbers. But am getting format error. This is the snapshot of my Systems module This is the expense drivers module THis is my Target module with Formula
-
When to use Lookup & Sum function
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 link to the lesson or explain the difference in term of when to use them. JH
-
To Hide Blanks Cells with multiple dimensions in a Module
Hi All, I have a scenario where i wanted to hide the blank cells. (Blank cells - switchover versions using DCA). As Per my below screenshot,i want to hide JAN 22, FEB 22 , OCT 22, NOV 22 AND DEC 22. Thanks, Aish
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello All, Need your help.I am getting Model object "'DAT03 Historic Volumes'.Export" could not be located for 9.1 Import Historic Volumes. Rest of the two : 9.2 Import Opening Stock, 9.3 Import Shipping Metrics are fine. Do I need to change DATA03 Historic Volumes Time Range from FY19-FY20 to Model Calendar? or could it…
-
Very Confused on Level 3 TAR01 Module
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 and all, but I think it has something to do with my G2 List. I have been trying to figure this out for 2 days now and…
-
3.3.12 Activity: Create Product Replenishment UX Page - Time context selectors
Hi, I have created the Product Replenishment UX page and it is almost look like the prototype page shown in the lesson. The problem is I am unable to put time context selectors on the page. Can someone please advise what am I missing and please review the screenshot of the page and let me known if there is any other…
-
Discover
Getting started is often the hardest part! To support you in your journey, we've compiled a list of valuable resources to set you up for long-term success. GENERAL KNOWLEDGE * The Anaplan Planual: The Planual is a must-read resource for all model builders as it establishes a foundation of best practices when building in…
-
Formula for First week of Timescale.
Hi Everyone, Could someone please explain this formula in layman's language. OFFSET(1, -1, 0) = 0 Thanks JH