Hi All, We currently have a "Positions" module that is not time based. We show our current salaries, job titles, etc. that comes from our payroll data here. This "Positions" module also contains the E…
Hi all, I have problems aggregating values from a module dimensioned with day, to a module dimensioned with month. I am doing rent calculations in a module by DAY time scale. When I try to aggregate t…
My source module has no time dimension but with month list, and period in line item. My target module has a time dimension Month Period, (ex. Jan 19, Feb 19, etc) How can I get the data from My source…
Question for the tech savy. E.g. The link below is the default URL for the page htps://us1a.app.anaplan.com/a/apps/app/b17cc9fb-23/boards/4d39-ff7302 Now when you send an automated notification from A…
A system that allows optimized scheduling of dates / times over a period would be very useful (for example a finite capacity scheduler in production scheduling, rather than a scheduling of a team for …
Hi, Could possibly someone help me to solve this problem? The output numbers (1'st Pic) are different than the correct solution. In 2'nd Pic you can see the correct numbers, which must seen at the end…
I've create on Data Hub the module SYS14 Create Account>Product and looks like: But I am blocked by Data?(Boolean) filter to determine if ANY data for product SKU under the product * If you are using …
We make a weekly copy of the demand plan to be able to calculate bias and forecast accuracy with 2 weeks lag. In a list we created versions : The last Property "Reporting Week" is formatted as Time Pe…
Hi Anaplan community, Whilst updating line items: Bonus, Car Costs, Phone Costs, Medical Costs I’m getting 2 types of error message: First error message: Data type mismatch: format other than LIST or …
I have mapped everything right , but the medical cost for December 2020 is showing 36,800 and that is not the right answer. Can anyone please help me with , where I am making the mistake .
It would save a lot of time and space to have percentile formulas in Anaplan. Percentiles are very valuable to eliminate extreme values from data sets and improve the accuracy of our forecasting model…
Hi all, I am beginning my journey as a model builder in a company where one of the first task is to try to optimize the current Anaplan Models, I've followed the instructions given here to try to redu…
What? A model analysis technique using metadata from your Anaplan model imported in to Excel, utilizing purpose-built formulas to identify line items of interest Why? We do this so that we have some e…
One of the most powerful "recent" functions I've used in Excel is IFS(), where a single statement can replace multiple levels of IF THEN ELSE statements. From Microsoft's description: Generally, the s…
Hi Guys, I am working on a module. where I should input the L1 then it should go L2 level. if I Enter the L2 then it should distribute L3. I can use the break back . I there any functionality availabl…
Hi guys I am working on an example we have a hierarchy as per my image: whenever i input the country wise then the country data should disaggregate to state level and also, from the state level to di…
Hello - I have modules dimensionalized by an L3 hierarchy (Co/Dep/Sub) with the line items equaling Accounts that are "collected" through a LIS. Now I want to sum my values into an L4; which is just "…
What are the alternative workarounds for this? When getting data from a line item Forecast version for a Quarter in which switchover occurs during the quarter, the QUARTERVALUE or [Lookup: <quarter>] …
Afternoon, Composing a typical growth forecast. I am having an issue when my raw data ends. (FY23 is the last year). Then once I get into my forecast years, the lag function (and previous function) ha…
In our work we need to frequently use several layers of nested IF THEN ELSE statements. These could be greatly streamlined by introducing IF and OR logical operators to Anaplan. For example: IF A = 1 …
Hi Anaplan users, I am trying to rank PO values by cost center & cost element & period & vendor & PO value. See screenshot and blueprint view attached to follow my reasoning below: I first want to sho…
Hi, Is there a way to restrict user access in certain list but they should still see the amount when being aggregated at total list. I need to restrict user to all modules so using the picklist would …
Hello, This question is related to user story 1.3 and 1.4 We want revenue for each account by product. Further we want to take its ratio against country’s previous years actual sales revenue by produc…
Good day I am working through sprint 3 at the moment and all is going well. However in activity 3.3.5.3 INV01 Inventory Ordering "Check your work" I have noticed that my amounts are slightly off when …
Hi Team, I am trying to calculate the "Average" for a Expense for the Period of "FY24". And I want to calculate using the Average from Q3 FY22 to Q2 FY23. On the "actual line items are the expenses fo…
Hi, I'm having trouble making this specific line item in a module into a subsidiary view, in picture attached. The line item i want to make a subsidiary view is Territory. Can i please get some help? …
Hi, At the end of Sprint 3 there is one lesson which says to Create Product Supply Manager Role so can anyone please help me how to do this lesson and what to do in this.
