-
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…
-
Can you pull line items into a modual from USERS list, fore example First Name, Model Role?
I am trying to set up some dynamic access within a model using read / write access drivers within certain moduales. I plan to do this by setting up a modual to set the access at user level using the user list as one of planning keys, but would be good if could pull in the assigned Roles, first and last name as would mean i…
-
Summing a line item based on time period in another line item
I'm attempting to come up with a total amount per period. However, the module I'm working with is not dimensioned. I have a month formatted line item called 'Period' and am hoping to sum up the 'Amount (LC)' line items that correspond with each Period entered. For instance, I'd like to see a total sum of the individual…
-
Different Time Scale problem
hi! I want to display the values from a module with a Time Scale of Half Year to a module with a Time Scale of Month. Can i do it? Please help me.
-
Circular References
Hi All, This is a pretty usual issue that I have seen others encounter as well but wanted to check if you have an elegant way of making it work. I am trying to calculate the available inventory at hand on a particular day using the closing stock on the previous day. So Day 1 would pick closing stock of Day 0 and calculate…
-
Deafult Forecast Errors
i m trying for Default Forecast and also with Round formula..I m confused about the formula. Can somebody help for this ?? I got the Baseline Forecast and Growth Rate%
-
COLLECT() function issue
Hi Community, Please see attachment for the details of the issue. Any feedback is appreciated Regards,
-
Level 2 Sprint 3.3.5.5 Final Shipping Method and 3.4.3 Country Made in
No matter how hard I try I am not able to the right formula for Final Shipping Method, so far my formula is "IF NOT Override Shipping Method OR ISBLANK(Override Method) THEN Shipping Method... Another query is do I have to give a formula for Country Made In line item...if so can anyone give me a hint?! Thank you in Advance…
-
Level 2, 3.3.5.3
Under INV module the JAN 20 beginning inv is matching Week 4 Beginning INV. Shouldn't the Beginning inv for a month be the same as Week 1? I keyed in some forecast values in DEM03* module. WIll this affect my results in SPrint 3? Hope someone can answer my queries THanks THomas
-
Activity 6 model building exam
The formula for 'REP04 Employee Expense Summary'.Salary is invalid: Salary = 'EMP02 Employee Expenses'. Salary[Lookup: 'SYS08 Employee Details'. Region, Lookup:'SYS08 Employee Details'. Role] The name 'SYS08 Employee Details'. Region used in the LOOKUP clause is not recognized as a line item in the model this error i m…
-
Activity: Add Formulas to Margin Calculation Module
why my unit price growth % didn't change even adding 5% in price growth rate plz help
-
Lookup not working - dimension used for lookup doesn't match any dimension of the source
HI I have 2 line items in the same module which are both in list format using the same subset list. I would like 1 of the line items to be completed based on the entry made in the other. I have created a mapping module using the same subset list as for the module and the line item (see attached screen shots). But when I…
-
11.3.3 Activity: Add Profit & Loss Report Module
Hello All, When I put this formula, IF 'SYS09 Version Details'.Forecast? THEN 'OTH01 Non Employee Expenses'.Shipping Costs ELSE 'DATA01 P&L Actual and Budget'.Shipping Costs I am getting this error The formula for 'REP03 Profit & Loss Report'.Shipping Costs is invalid: Shipping Costs = IF 'SYS09 Version Details'.Forecast?…
-
number of months left in the model calendar
Hi, I'm looking for a way to reference the last month in the model calendar. For Example My model Calendar is 1 previous year and 2 future years. Currently the last Period is June 2022 however when the model calendar increases i want the formula to reference the new end period. I then want to count the months from the…