-
Optimizer Error message
Hi, I am building a small optimization model, I am getting "Constraint does not exist" error message. I am not able to identify why I am getting this error. can anyone please help? Thanks, Sourabh
-
Formula for current month
Hi, I need a formula that can give me the actual Last day of the current month. As the current month is October'21, I want to get the result as 10/31/2021. Can someone help me with the formula or guide me with a way around.
-
Lookup for top level item not working
I have an aggregates sales forecast module that only has time dimension. The sales line item in the aggregation module is doing a lookup at sales metrics module that has stores and scenarios as a dimension. When the lookup against the stores is the top level item "All Stores" it returns 0. But in sales_metrics screenshot…
-
Level 1 Model Building 7.2.3 Activity: Importing Numbered List SYS08
Hi, I am having trouble importing the Data - file Employees.csv - for SYS08 Employee Details module. The data is not looking like it should and I have tried to map it multiple ways. It is a numbered list and they give that as a hint, but still not making sense to me. Can someone please help?
-
Level 1 Lesson 8.5.3
Hello I have been stuck on this activity for days now, I had searched the community for similar issues but could not find any, my mapping on G3 and P2 doesn't automatically map and it causes an error,
-
Any straight way to know the start month number as per Current FY?
Hi Friends, is there any formula / straight way to know the month number of the Current Fiscal Year? e.g. if the CURRENT FISCAL YEAR in Time Setting is as below Then Apr'2021 is first month of FY22. How to calculate like below? TIME SCALE --> Apr May Jun Jul ...... Mar LINE ITEM --> 1 2 3 4 ...... 12 Please suggest!
-
Unable to open my existing Models in my Workspace
Hi Team, We are facing issues while opening my existing Models in my workspace, last 3 hours back i was able to access my Models but now i'm unable to access. Could someone please help me here. We are aware that we have scheduled Platform Maintainance activity in next couple Attached the Error screen for our reference.…
-
Distinguish RANK formula starting value
Hello, I am wondering if there is functionality which would allow ranking based off of a specific starting value. For example, I have 'Reference Line Item' = 3 (number formatted). I then have my 'RANK Line Item' which includes my RANK formula. I would like the 'Rank Line Item' to start ranking from the Reference Line Item.…
-
level 2 sprint 1.4.6 actions
its getting difficult to import action in process please someone help me to understand this
-
2.3.11.3 Create Line Chart Saved View
Hello, I'm attempting to create a line chart as a saved view. When I create the line chart, I'm asked to Publish to Dashboard, I then select Line Chart, but am having trouble saving the line chart as a view.
-
SUM weeks into Months
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 replicate in native settings. Therefore, we created a mapping to map weeks into the month but I am receiving the following…
-
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.
-
Remove 0 entries from the line items in a module
How to remove zero from line items in a module .I have applied filter but there some columns having Zero .
-
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…
-
Model with Two Different FY start
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 Jan - Dec. One Option is to achieve this using Fake time in the Model. Is there any other suggestions/workarounds to achieve…
-
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…
-
How to get an attribute to show at all planning levels to use filter
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, which is determined based upon the L2 Department Level. I think that this is a dimensionality issue and there is not a…
-
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…
-
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…
-
Filtering a GRID-NEW UX
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 columns, above that as columns as I have the line items and above that Attribute List 1. So my end table would look large…