Hi All, I am receiving a very unexpected error when trying to SUM Anaplan weeks into Anaplan Months. The reason we are doing this is because the clients has an unusual calendar that we are not able to…
It would be very useful if we could pass page selector values as parameter in the URL, this way we could provide links to end users with a predefined selection and/or provide a more dynamic navigation…
Hi, I have created a numbered list module with no item yet (Refer to image 1) When I import the transaction file into the module (image 2), what can I do to auto create item in numbered list (#1, #2, …
Is there an easier or faster way to copy data from FY21 Forecast version to FY22 plan version without copying it module by module? Also, I need to keep the current FY21 plan intact. so the result on p…
Hello, May I get help with this part. I tried to add formulas to these line items but it does not work". There is an error each time. Unit Price Growth: IF 'SYS00 Time Settings'.Forecast Period? THEN …
I have Line Item A, Line Item B, Line Item C, and Line Item D. How do I get the average of those line items? I know I could add them and divide 4 but I was wondering if there was a formula? I tried th…
What is the purpose of a specification that allows a list with no parent hierarchy to not only have children of the top-level element, but also to add to each child itself further children belonging t…
Hello guys, could some kind soul help me with this ? i have two modules: - module 1 : line item "account" list formated, list name is "group account" , line item "partner" list formated and list name …
Hello all, I am having a problem with Inventory Ordering Module. I thought I did everything correctly but my module's suggested order amount doesn't match with the given screenshot. Here is my module …
I have a time SYS module that has the last month of the next years forecast (12/1/2022). When I use the PERIOD() formula and reference this line item it returns nothing. The module where I am referenc…
Is it possible to have period start/end selectors to pick the run rate period instead of a moving average? Each time we add actuals it changes all the forecasts making previous adjustments and overrid…
Hey everyone, I am encountering what seems to be a bug with one of the modules I am working on, where the summaries of the line item seemingly do not update after a change in values. As you can see in…
There are times when a code needs to be generated in Anaplan and it would be really handy if we could use a simple hash function to do this (especially as Anaplan's code limit is 60 characters). The H…
Hello Community, I have a use case where I have to use two different FY Start Month i.e., In my entire model Fiscal year is from Apr to Mar, but there is a special scenario where I have to Use FY as …
Hi, I am using a TIMESUM average and I'm wondering if there is a way to exclude zeros from the average. Formula: TIMESUM(Build Factor, TIME.'Q2 FY16', TIME.'Q4 FY19', AVERAGE) Pictures attached.
Hello all, I need to calculate a sum of costs from P&L which are base for subsequent calculation of revenue (sum of costs * (1+margin%)). The tricky part is that we need dynamic setting for identifyin…
Trying to pull the SUM of X list from a module but receiving the below error. Source module is having a list datatype line item i.e. COST CENTRE (though dimensioned with other list) and the target mod…
We have three planning levels and want to be able to filter based upon an attribute of one to show all three. L1 - Client L2 - Department L3 - Product The attribute we want to filter by is Territory, …
Hi All, I am wrapping up the Level 2 training and am stuck on why my data for everything new york is not populating. My guess is that I do not have 'submit purchase order' as a formula and therefore t…
According to this mini demo, time-functions are divided into two categories: non-time series functions and time series functions. Non-time series functions include: * ADDMONTHS, DATE, DAYS, END, INPER…
September 2021 Release and Sneak Peek at October 1. Pasting into Breakback Cells: Within UX, now it’s possible to easily paste values into Breakback enabled cells which are highlighted by blue markers…
A relatively simple request. But could we have a summary style option that is the same as Summary 2, but with the above the cell? To me this would be used for subtotals and it just makes more sense th…
I'm using Line Item Subset to filter line items. This filter would be published in the New UX and the user will be asked to select the respective Line Item and the selected line item would be displaye…
Hi guys, im trying to do this lookup. I will start by stating the goal i want to achieve: i have 2 lists formated line items in module 1: Product and Partner. In module 2 i have one list formated line…
I have two modules, the first includes versions as a dimension and the second doesn't. There are 4 versions, Actuals and 3 forecast versions, with one of the forecasts marked as current. If I create a…
Hi All, I am trying to write formula for shipping time in weeks line item in INV01 I am referencing TRA01 shipping time(weeks) as source in my lookup and SYS08 code as Mapping. and I am seeing that TR…
Anaplanners, Module A dimensioned by Projects, Time, Attribute List 1 and Line Items. I have projects as row headers (which has to be filtered based on Users and other conditions). I have Time as colu…
Hi, I have a P&L with 20 line items currently in a module. This has 2 other dimensions Entity & Division which are Lists. It has native versions as well and monthly time. I'm trying to create a new mo…
