-
Using List Properties
Hi All, Why is it best practice to avoid using list properties? As a central location to hold all the data relevant to that list that does not require the user to update it seems like a perfect option. I am referring to properties such as all items of the hierarchy and permanent mappings that will never change. My question…
-
Formula DCA to lock cell
Hello, I need some help with a DCA. So I have 3 line items weekly dimension : X (number), Y (number manually input) and Z Yes or No. So : If I select No on line Z, then line Y should be 0 (blank) If I select on line Z Yes and if line Y is not 0, then the line Y for that week (cell) should be locked If I select on line Z…
-
Referencing a line item that has formula summary method, not displaying correct number
Hello, In the example image, I am referencing a line item "TV Programming (Final)" in another module using an If statement IF XXXX THEN XXXX.'TV Programming (Final)' ELSE 0 However, it isn't pulling 4,063,964,538 as expected. I know its an issue with the summary method being set to formula because other line items are…
-
Previous list item in formula
Hello, Is there a way to assign a value depending on the previous list item? In my case, I need to assign the value 1 to the week 5, value 2 to the week 6 and so on until week 9. The values always go from 1 to 5, however the week number might change (for instance, choosing RFC24/01, value 1 is to be assigned to week1 ecc)…
-
Time Dimension & Value not adding correct
I have a model which has the time dimension (in days) and line items which are date formatted. I'm trying to create a chart which correctly replicated the progress of time change but for some reason any value is not mapping to the x axis of the chart. I have attached a picture for better understanding. In the picture you…
-
Replenishment modeling with circular reference
Dear Anaplan Community, I am facing a circular reference issue modeling replenishment calculation. For this specific client, their trigger condition to place an order is to evaluate below condition: If I do not place an order today, will my projected end on hand (EOH) on this Item's ETA date fall below this item's safety…
-
Revision tags with multiple builders
My client is asking what is the best way to allow multiple model builders in Anaplan independently? In the current system there is no way to isolate what changes should be moved to other environments, i.e., revision tags are cumulative. How do you all handle this?
-
Summary Method for Lookup function
Hi, What is the best workaround when using the Lookup Function and you need a Formula Summary Method? Currently, Anaplan does not allow this and for some cases, especially using % accounts, it is best to use the Formula aggregation in order to get the right math at top level hierarchies and Time Summaries (i.e, All…
-
Formula Summary for reporting
Have to run a variance reporting for 3 Line items. In the source, the line items have dimensions and Time(Quarter). The variance Reporting module is run by the same dimensions, the source line items act as a dimension(by line-item subset) and looksup the Year selection by the user. The challenge is that one line item has…
-
I NEED HELP ASAP
Hello, I need your help please!! I wanna import this file CSV in a list on Anaplan without edit the file. should i import the file in a module and create a code for each line then import the view in the list ? and how to do it ? thank you RGDS
-
Is it possible to colour input line items for ease of inputting. For eg as added in the screenshot.
Is it possible to colour input line items for ease of inputting. Also this colour should be present even before any data is inputted.
-
Adding list items, but only display the result when a list item is selected
Hi all, I'm experiencing an issue in my module where when selecting a certain list item ("online" - in the screenshot), the numbers aren't displaying as they should, and I'm getting 0 in every line item. I think this is a build issue, however I want to try a hotfix by adding two different list items that I know total to…
-
Calculations with list items
Dear all, I created a line item "Figure" and a list "Divisor". The list just contains two values: 12 and 24. I further created a line item "Result" which should display the result of Figure divided by Divisor. So my module contains three line items: Figure: Number Divisor: List Result: Number Unfortunately Result = Figure…
-
Converting a Classic model to Polaris
Hi, Is it possible to simply port an existing model built using the classic calculation engine into Polaris? Thanks,
-
Formula to allow duplicate
Hello, I am trying to make a formula in order to be able to create duplicate codes. At the moment my formula goes like this: IF Boolean THEN Concatenated Code ELSE Blank And I want for my formula to do this : IF my boolean is checked, then my formula should return the Concateneated Code but i want to allow a duplicate not…
-
Time dimension formula
Source Module has Year, Target module has Months. Source - Time dimension (YEAR), Cost center dimension, Line Item Target - Time dimension (Months), Cost Center dimension, Line item Source has rate by year, for example for FY23, Want to bring FY23 rates to all the months in target module. What formula would i use in terms…
-
Formula SUM
I have A List of Farms - 'FarmNames' - showing the Farm name, and a Property - 'Shop NameShop Name' -which shows the shop the farm serves. A module - 'Farm Apples' - showing the name of the Farm, and the manually entered number of apples by month for the past two years, where apples is the only line item. I want to show -…
-
Assign values to duplicate items
Hi I have below module that is update every few days UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan two records were updated when the next time(eff from) the job runs like below UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan 5 A1 25-Jan 6 B1 25-Jan I want to…
-
Is there any way to export the line items wise view, by using export action(date format line item)
Line-item kept in page selector as Date format
-
Setting time as forward 52 week
Hello, For my model, planning cycle we look at it forward 52 week. The planning cycle start at the beginning of each quarter. so if we are in Q2 2024, 52 weeks will be from Q2 2024 - Q1 2025 I see option to set week as calendar type but for planning year, I can only select complete year. The only option I have is to select…
-
Change fiscal year without losing Data
Hi Everyone, Is there a workaround to change the fiscal year of a model without losing the data? My colleagues made their planning in a model that has timesettings for 2018, but they want to change the Fiscal Year to 2019. is this possible without erasing their data (which is manual input)? The Model only knows the current…
-
Hot fix
Hi All, I couldn't get clear outlook of implementing hot fix in prod environment, when we have development in progress in dev mode. We don't need the development to go to prod only the issue needs to be fixed and later we must progress with the dev model with out loosing the development. I am unclear of how many revision…
-
Bill of Material Explosion - Best Practice
Hi, Pondering my head around a Supply Chain use case where a bill of material explosion is required with an undefined amount of steps to get to the lowest level. This should be an iteration where an SKU can have a one level explosion or up until 6 levels of bill of material. What is the best practice of Anaplan to set this…
-
3.3.5.3 check your work numbers are out (most likely Dem03)
Hi team, Working through the level 2 model builder course and have hit a snag. My Dat03 Historic values is populated and working as intended with the forecast year pulling the value from the previous year I believe my demand forecast is also working as intended with FY21 pulling from FY20 My issue is my final forecast is…
-
Dynamic Cell Access
Hi, I need to apply two DCA in one single module. It is like I have done driver based planning and applied one DCA with that. Another DCA I need to apply is for approval. Like if a checkbox in one line item is approved then related module line items should get disabled. Can anyone please help? Thanks
-
Why am I receiving the error "Not a recognised line item or list member" in my example?
Hi Anaplan Community I have two modules (“Allocations Stage 3 Mktng Media Allocation Result” and “Allocated Expenses”) that I want to link together but I am getting the error “Not a recognised line item or list member”. Below is the blueprint of “Allocations Stage 3 Mktng Media Allocation Result” Below is the blueprint of…
-
how to average on roll up
I have a module where I have sales per country. I want to average sales and not add when I roll up to region or when I chose region from drop down. How can I do that?
-
Help on Selector
Say I have a module with multiple different items and each item has a sales amount, a corresponding sales region, customer, and line of business. I am trying to build a dashboard where I can view sales amount by customer, and then have sales region, line of business and other options as a filter. I have built a separate…
-
Help on circular reference with POST
Hello, Do you know if it's possible to force the formula POST like LAG with STRICT argument. My use case to be able to POST value in the future for stock equation. If I use LAG(value , Leadtime , STRICT) or POST(value, 2) the formula are ok If I use POST(value, Leadtime), I have a circular reference. So I try to help using…
-
Automated Loads not working | Working when manually run
Hi, Facing a strange issue. We have a process of around 15 actions that takes snapshot from each module and its automated and run using an integration account (full access). Strangely the same is not running in one the UAT environment, while running automatically in SIT environment. Also, when manually run its successful…