-
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
-
Automatically sum line items of a module
Is there a way to sum all the line items in a module? Let's say I have 20 line items in a module at the moment and I want to sum it all up in the 21st line item. (1) Is selecting 20 line items one by one to get the total the only way? (2) Is there a way to ensure that if a new line item is added somewhere between 1st and…
-
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 Store P1…
-
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…
-
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