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 shou…
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…
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 suppos…
Confused on how to work with this flat data and derive monthly values from it. Appreciate the help! Each row is a unique combo of Account (GBAID), Ledger Type (GBLT) and Year (GBFY). The snippet attac…
Hello all, I'm trying to delete items of a list that are not linked to a parent. Therefore i cannot use "the delete from list using selection" action. Do you have any tips to achieve that ? The list i…
We are working on a project to migrate from an Employee Hierarchy to a Position Hierarchy in Anaplan and are looking from some input from the community on Code Creation best practices. Since we do not…
Imagine you need to update an export with a new column, but you want to retain the previous export for another group. In order to create this new use case, you now have to create an entire new export …
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 certificatio…
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:
Hello, I am new to Anaplan platform. Now I am working on Level 2 model building training. Here I have an issue to write a formula to line item. I don't have any kind of data in SYS13 Account Filter Mo…
Hi, I have a formula applied to a line item which is not giving out the correct result, and if I drill down the formula, the pop-up screen is not considering he other modules for calculation which are…
Improving forecast accuracy often features the business value expected from a system implementation like Anaplan for demand planning. In reality, forecast accuracy is not a business value—but it contr…
Hi, I have developed an app with several pages in it. Total 60 users are having access to this App and all are with same access. And i can see one user is getting an error when he opened a page in the…
Hi All, I am unsure why the Import is failing whilst import into dimensioned / non-dimensioned module.. Import snippet: 1st & 3rd columns are List Item Property Whilst Import it is failing due to dupl…
Hi I'm on question 6 of Level 1 and I keep getting this error. I've double checked my format and names and think they are right so I don't know why i keep getting this error Medical Costs = EMP02 Empl…
The formula for 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' is invalid: Datatypes do not match for 'IF' function: NUMBER, BOOLEAN I used the formula IF 'SYS01 Time Settings By Wee…
Hello, I have a problem with formatting a line item. In the source/input module I have a many line items, some of them are presented as % and some of them are as normal number (No problem here, becaus…
Hi Anaplanners , I would appreciate if someone in the forum could help me to resolve the below modelling issue that i have. I have 4 dimension on which the business needs to do their planning ,forecas…
I am trying to populate this module and I have hit a road block (yet again with mapping) 😭😭😭 Can someone please explain what I did wrong - attached are screenshots of the mapping and the code I was…
Good morning I am building a model consisting of future variable monthly cash outflows without any cash inflows. I need to calculate the NPV of that in order to convert that into a liability using the…
I am trying to populate this module and I have hit a road block (yet again with mapping) 😑 😪 Can someone please explain what I did wrong - attached are screenshots of the mapping and the code I was …
Hello I am facing a scenario where I need to implement Slow Changing Dimension ( Time Validity using Start Data and End Date ) for product & customer combination. A product can be sold to more than on…
Hi All, I am faced with this hierarchy where P1 and P2 are parents and Prior Items are Children of it. I am bit confused how to build this hierarchy in system as data for both child are in same column…
while writing the formula for safety stock flag count line item i used this formula 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS08 SKU Details'.Country Made In ] But it is giving e…
