-
Anaplan Way Certification
Hi All, I want to enroll for Anaplan Way certification but it is showing to enroll in classroom classes. Kindly guide me on this how to enroll for Anaplan way. It would be helpful. @Misbah Thanks , Ayush Srivastava
-
level 1 exam activity 5
added all the formulas for bonus ,car allowances,medical...but adding all car cost, medical are showing zeros
-
How to look up first instance of a numbered list
I have a module (Module A) that applies to a list. Job Title Salary Bob John Katie I have a different module (Module B) that uses a numbered list. The display names of the numbered list matches the names in the regular list. How do I look up the first instance of the "Job Title" in Module B so Module A shows Bob's Job…
-
Allocating 53rd week to previous 4 weeks of the same year?
I have a scenario where in a module I am getting 53 weeks of data but the client does not want the 53rd week to show instead client wants that the data for the 53rd week should be distributed to the previous 4 weeks. Could you guys please explain how can I achieve this. Thanks a lot in advance. @Misbah any inputs on this.
-
Error message L1 model building - 6 Module 6.6.5
The formula for 'SYS01 Time Settings by Year'.Forecast Year? is invalid: Forecast Year? = 'SYS00 Time Settings'.Forecast Period? 'SYS00 Time Settings'.Forecast Period? is not a recognized line item or list member I received this error message when I try to enter formula to the line item Forecast Year And I am also not sure…
-
Sprint 3 Beginning Inventory Formula not working, getting an error
HELP! I'm currently doing Sprint 3 and I'm getting error with my Beginning Inventory formula. IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory I'm getting the error below. What can I do to fix this? Is my formula incorrect?
-
BREAKBACK - Is it possible to release one cell that have just been hold
Hello Anaplan, Using breakback we can hold cell by cell to keep an amount. We can then "release all" hold cells of the grid. But is there a way to release only one cell ? Exemple : Hold cell 1 Hold cell 2 Finally release cell 1 only
-
How can I maintain past data when changing formulas?
Hello, Anaplanners. I hope this message finds you well. I wanted to discuss a challenge I'm facing while working on an activity-based costing model in Anaplan for my end-of-study internship project. Unfortunately, my professor has expressed doubts about using Anaplan for this purpose. The main concern raised by my…
-
Synchronized selection issue
Hi Anaplanners, So I have a Region List (R1) and project list (R2) rolling up to these Regions. Within R1, we identify special regions using a boolean line item in a separate module. I have a NUX page where all the attributes of only the 'special regions' that is R1 filtered with the above line item, dsiplayed for the end…
-
Sum function not working correctly
Hi, I have a data module with Dimension E3-Emp. This data module has following dimensions as List type Line items (Site, Tier, Rate, Tenure) When I try to create a module to group Emp HC by Site, Tier, Rate, Tenure and E1-Emp Class ( Super Parent for Emp). The result doenst look good. My formula 'DATA01 EMP Roster'.HC[SUM:…
-
Find occurrences of a Dimension code without hierarchy
Hello all, I'm stuck on something. I have a Job dimension that has Job code and Job name. (100 - Tech I) That Job flat list is not in a hierarchy. But I've created another list called JobL5 that has the Department as a Parent. Each dept will have several jobs listed underneath. And the same job can be in several depts. I…
-
How to avoid counting multiple times when summarizing
Hello everyone ! I came to ask a question here with a case i'm sttrugling with, i hope i will be clear enough with my explanation, don't hesistate to tell me if it is not clear. To contextualize a bit : i'm working basically with two hierarchical lists that goes from : GP0 Zone, GP1 Region, GP2 Country, GP3 StoreP1…
-
DCA Logic on selection line item
Hi Anaplanners, I have a module where I want to apply DCA on "a" line item. The logic should be that if no region is checked, all regions should have write access, but if any region is checked, only that selected region should have write access, and the other regions should only have read access. The "Region" list used in…
-
target with more dimension than source
Hi I have source module by GEO and ORG, However, I have target module by GEO and Time dimension. In the source module there is a mapping between GEO and ORG, So the line item is list formatted. How do I get the mapping to the target module. For example, if GEO 1 is mapped to ORG 1, I should get that in the target…
-
Target module with less number of lists
In my situation here, I have a source module that has two dimensions - EMP and Geo and Time and line item called MAP which is list formatted (GEO). Target dimension has one dimension EMP and Time and line item that is list formatted (GEO). I want to bring in the Geo from source to target in this case. Since the target has…
-
Level 3 Sprint 4.5 Finalize Assignments Action Button
In the screen shot for 4.5, there is an action button for "Finalize Assignments". I have read through the user stories and the in the build steps and I cannot find any reference to this. What does this action do?
-
How to Count the recurring combinations of List Members
I want to Count the recurring combinations of Time, Employee, Project and Fund but the issue is that the List is too big to use Sum function, I need some other means as I cannot even create a TRID for it due to lot of List Members and also I am unable to create a Staging Module or anything like that to do the task. I want…
-
Entity or Country First
Hello, We're considering launching into a new country, how would be best to structure this in the organisational hierarchy? Country first, then entities; or entities, then countries. For reference both entities will be trading in both countries. e.g. Total Company > UK, Germany > Entity 1 - UK, Entity 2 - UK, Entity 1 -…
-
How do we take the Current User and apply a filter on a view?
We have created a module SYS11: Current User with dimension Users. Per the instructions found we set in Blueprint Users List = Show all users:Off Now we want to take that user and apply a filter to Sales Detail on UX page to show only the transactions related to that logged in user. We are struggling to figure out how to…
-
SYS00 Time Settings'.Forecast Period? is not a recognized line item or list member
Hi team am receiving an error
-
Get the values from one cell data to another cell
Hi Please go through the screen shot source: it is input by the user Target : we have period dimesion . now i bring down the data from p2 to p13 at what they inputed. for Dp1 conventional. they want take value from CV vol coff -conventional. for organic they want to take from og vol coff . in sys module i will add another…
-
Help me with a formula.
Hello Community, I´m trying to get in a module from a formula to know if an employee has for reporting only and distributor accounts here is my formula: Here is the module from where i want to pool the info: Not sure why but my formula on the Has report only or distributors accounts are not working as intended, not sure if…
-
How to get the values form different time periods
i want to get the values from non time period to time period module. how shouid i get it
-
What is the process for viewing a workspace map like a model map in Anaplan?
Hello, I'm attempting to figure out how to examine workspace maps, similar to Model maps. It will be useful for us to keep track of the dataflow between models. Is there anything we have for Anaplan? TIA
-
Displaying an Incorrect Version of Data
Hi All, I just would like to check if anyone experienced the issue wherein affected users are viewing an incorrect data (ie. Actual was selected as version on context selector however, the report in Apps shows Budget data). I tried to replicate the issue by giving the same role permission on my account as affected users…
-
How to Select the Current Fiscal Year
Hello, I have a data module that lands data in a monthly basis. I then created a module that has Q1 to Q4 line items - the intention is to get the data from Mar 23 for Q1, Jun 23 for Q2, etc. So I then created a module with the below line items and with the year as my time dimension and put a formula in each of them so the…
-
Forecast and annual plan in parallel working in a single model
My forecast periods ends 4 weeks before the annual planning number submission. I need to find a way to use the model simultaneously for forecasting and annual planning. Is it possible to achieve? The model is also interconnected with other models. Can time and or version dimension be the solution?
-
how to decide the completed years(Length of service)
hi guys~ In Sales_Rep_Details module, What we know is the sale start date, so I calculate the completed years by: Start_Date_Current_Period(2020-01-01) - Start Date then I devide it by 356 the final formula is ROUND(('SYS01 Time Settings by Month'.Start_Date_Current_Period - Start Date) / 365, 0, Up,NORMAL) by compare my…
-
vLOOK Error "'REV04 Price Growth Rates'.Unit Price % is not a recognized line item or list member"
Hello, i am getting error message "'REV04 Price Growth Rates'.Unit Price % is not a recognized line item or list member" when i am trying to apply vlook formula.
-
Select Data using a Boolean from a module with other dimensions
Hello, I have the three following modules: Pick Year: Dimensions: Product, Forecast, Time (Year) Line Item: Select (Boolean) Employee Sales: Dimensions: Employee, Market, Time (Year) Line Item: Sales (Number) - Filled with a flat Sales module (Flat Sales Module.Sales Amount[sum: Employee, sum: Market, sum: Year]…