-
copy between versions - current year to next year
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 plan version should be FY21 plan + copy of FY22 Forecast. This is a model level change. Lag function doesn't work on version…
-
9.2.6 Activity: Add Formulas to Margin Calculation Module
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 YEARVALUE('REV05 Price Growth Rates Staging'.Unit Price %) ELSE 0 Unit Cost Growth %: IF 'SYS00 Time Settings'.Forecast…
-
How do I get the average of a line item?
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 the average formula but I don't think it works in this case.
-
If and lookup between lists and modules
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 is "partner" - module 2 : line items are : - account the same as in module 1 but text formated - group : list formated, list…
-
LEVEL 2 SPRINT 3 3.5.3. INV01 Inventory Ordering Module - Suggested Order Amount for the Month -
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 as you can see I get 8,192 for the suggested order amount. I should be 8,194. Here are my formulas. Any hint appreciated,…
-
Why is my Period formula returning back nothing?
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 referencing does not have time as a dimension. Could this be why? Time SYS: The module where I am attempting to reference: Thanks in…
-
Run Rate Period selectors instead of moving average
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 overrides obsolete requiring re-work.
-
[BUG?] Summary Items showing non-zero values for Line Items with zero values after running Optimizer
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 the images attached below, the summary levels of the line item shows non-zero values even though the children cells are…
-
An Anaplan Hash Function
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 Hash function could be a simple one that allows input of text and generates a code limited to 60 characters or less. it might…
-
Exclude Zeros in Time Sum Average
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.
-
Summary over Line Item Subset
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 identifying the costs to be aggregated because each year different cost might be considered as part of the base. I would therefore…
-
SUM is making the formula invalid
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 module is dimensioned with the subset of the same list COST CENTRE. When trying to SUM HeadCount based on CostCentre then the…
-
Level 2 Conclusion/Sprint 3
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 there is no actual shipping occurring in the model other than the ones selected for NY. If someone could please provide some…
-
Difference between Non-Time Series Functions and Time Series Functions
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, INPERIOD, MONTHTODATE, START, YEARVALUE. etc. Time series functions include: * PREVIOUS, NEXT, POST, LEAD, LAG, SPREAD. etc. I…
-
L2 Sprint 2 - 2.3.10 - Create DEM03 Demand Forecast Module
I have inserted a formula successfully but i am not getting any values for other line items. Can anyone please help in this regard.
-
Lookup between two lists formated line items
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 item called "quantity". in module 1 i have a line item named "auto" that should be auto filled according to user's…
-
Interaction of version and non-version modules
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 line item in the second module (with no versions) and reference a line item in the first module (with versions), what data…
-
L2 Sprint 3 INV01 formula for shipping time in weeks
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 TRA01 is at P2 product list and SYS08 is at P3 sku level. How should I connect these 2 to avoid error. Please guide me in…
-
Line Items with Version LIS
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 module which takes some lines from this P&L with different combinations of Entity & Division which I'm comfortable creating…
-
view to view import failing
Hello friends, need your help in nailing down the problem which i am unable to point. * Module test has 2 views..1a and 2b * Module has following dimensions i.e. Model TIME, 2 lists & 2 line items * What I am doing is inputting the view 1a data into 2b view, receiving the below error. Not sure which data is getting…
-
Exam Activity 6
I know I can't get answers, but I feel like everything should be correct in my formulas. However after I entered all of them, they just populated 0's. I've checked the source material it's pulling from and it's all seeming accurate. Could someone help point me in a direction to troubleshoot the lack of data? Thanks!
-
Recreating Excel Formula in Anaplpan
Hi, Trying to replicate this same Excel Formula in Anaplan, but leads into a Circular Reference. Please advise on how would do so. The Excel Formula and the Formula we are attempting to us in Anaplan are below. Excel Formula: =IF(AND(AJ31=0,AK31=0),AJ103*AK$71,IF(ISBLANK(AK31),AJ31*AK$71,AK31)) Anaplan Formula: Thank you
-
What are these fiunctions for?: HALFYEARVALUE, QUARTERVALUE, WEEKVALUE, YEARVALUE
Can anyone tell me what these functions are for? I have read Anapedia but still having a hard time understanding what they do. MONTHVALUE HALFYEARVALUE QUARTERVALUE WEEKVALUE YEARVALUE In the sample below, I guess that "each weekly sales" are compared to "average weekly sales." And it turns out to be "True" if a weekly…
-
Totals (across a list) without a parent member
I have a module that is dimensionalized by row ID (#1-#n), no parent member for that list. It is an input template to model new expenses. What I am aiming to do is to have another line item (could be in a different module if needed) that will look to see if any of the rows have data. Essentially each row has line items…
-
Time period check box
hi! When I tick a checkbox for a year, I want that month to be displayed in full. I think it's simple, but I can't do it. Please help me.
-
Ability to create Formulas between models
As a workspace admin, i need to build connected planning between models, meaning direct formulas references between models themselves. This is needed as our current only option is to either use import actions which need to be either run manually, or scheduled through cloudworks or would require a substantial amount of…
-
Serial Numbers in Anaplan
Hi All, I have a module with a subset of numbered list applied in its dimension. We want to derive the S.No/ Count of Items in the list in a line item in the module eg: If the list has 3 items A,B,C in the mentioned sequence itself then corresponding to A in the line item built we need 1 then corresponding to B we need 2…
-
ISACTUALVERSION - correct Output
Here's the official documentation on the formula - https://help.anaplan.com/138ee6b0-34a3-4654-b944-f655e6b28ad8-ISACTUALVERSION As per the article, ISACTUALVERSION returns TRUE for Actual Version and FALSE for all other Versions. However, I observed that the actual output is different when you use Time as a Dimension.…
-
Level 1 Activity 9.2.6 add formula to Margin calculation Module- Cost of Sales
Hi I am on learning level 1 activity 9.2.6 of Anaplan. I am struggling to insert the right formula for cost of sales formula as per training module is : Cost of Sales'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Cost * (1 + Unit Cost Growth %) All the other formulas are working well. I also tried to write the…
-
Conditional Formatting rule Inputted by user
Hi Guys, I just want to ask something. Now in the conditional formatting screen we have the range of MIN MID and MAX right as the basis for the color of the cells in Anaplan. Is there a way where the user will be the one to input the threshold (is the term we use in the model) or the MIN MID and MAX. in my example below I…