-
How to sum a previous period value and current period value (multiple times)
Hi all, Have been trying to sum the values from the last week and the current week to obtain a new cumulative value; this value will be the new value to be added to the current week value. Unfortunately, this does not seem to be so easy in Anaplan. WEEK1 I start the first week with one value (layers-actual) and, of course,…
-
Is it possible to retain data when amending the Week Ending Label?
Hi Is it possible to keep existing data already in the model when amending this time setting? I originally set up the model to be W/E on Sundays but now the requirement is to change it to Fridays. We already have a lot of data loaded in against weeks, is there a way of keeping this in the relative week?
-
How to sum the values of specific days of the month. Ex. sum the values of all the mondays.
Hello, I have a requirement for the client to find the ratio of the days of the week over the value of the month. To do this I need to sum for example the value of all the Mondays of the month and then divided by the value of the month. I though about making line items with just the value of that day of the week that I can…
-
Numbered list ?
I am unable to get this right i am getting this but the correct one must be
-
Best Possible solution - Master data changes
Hi, I would like discover best possible solution. The integration happening from SAP to Anaplan (daily basis). The issue is that whenever there is a change in the master data , it is impacting the final #s of budget / actuals / forecast which is obvious. How do you overcome this scenario? Like budget needs to be locked…
-
What have you found to be the biggest roi in terms of model optimization?
I have a very slow model that I want to start optimizing. There's obviously a lot to do. Anyone have any great success stories? What did you do? Where should I start?
-
How to Identify First Month of Every Year?
-
Delayed amort of assets at category level
Hi Team, Need some help with a bit of a head scratcher. I am working on an asset forecasting module at a category level (due to requirements outside of my control we cannot input the values in at the individual asset level). The categories are in their own list and I have a simple module that houses their life for…
-
Transfer boolean information from a module to another (different lists being used)
Hi all, I am having a hard time trying to put to 2 differently structured modules into communication . The goal is to get the boolean to work as filter for the so-called FAB products. Here are the two modules: DAT11, one-list module: ID Revenues this is the source module from whom I need to take the "Is Fab revenue cost…
-
"Export Directly from Spoke Model" or "Import from Spoke to Hub and Export from Hub"
Hi Everyone, This question has probably been asked before, but wanted to get opinions on the two options. I have heard hard-lined opinions that outbound data should always be brought into Hub and then exported to another spoke model or external system. I've always taken a combined approach that focuses on mitigating the…
-
I want the Minimum value of a product amongst same months but different years
Hello everyone . I have a question that could not find an answer for it . I would appreciate if someone could find a way to solve it . thanks . Question : I have a module that has two dimension : 1. Time dimension that has 2 years and the scale is month. 2.Product list In this module I have a line item named Value which i…
-
Getting error on UX page: "The value entered is not valid"
Hi All, I have the below module setup - New Manager Line Item has a dependent dropdown to show employees from the same department. Later I am referencing Final Manager value in a Employee Summary module while is published as a Field Card on the UX page. But, it keeps showing "The value entered is not valid" under the Field…
-
which is the worst performance function below ? A. Rank , B . RankCumulate, C. Sum , D. Select
-
MIN monthly value of the year on custom timelist
Hi team! I have never used the MIN function or aggregation in anaplan before and I am having some problems now. Sorry if the solution is too obvious. I have module with Plan 23 / Plan 22 lineitem with dimensions: 1. Product. 2. City. 3. Custom Months list (January, February etc.) Screenshot of module below: In lineitem…
-
FINDITEM on numbered list ( display name )
Hello, this is my problem. I import a file in my STG03 module, dimensioned by the STG03 contrat list. This list has a property "Tiers" which contains the tiers names, in TEXT. I also have a Tiers module, dimensioned by a Tiers numbered list with code, and display name which are the tiers names. I want to turn the TEXT line…
-
How can I efficiently extract and integrate just the anniversary month into our existing model?
Hello Anaplan Community, I'm currently facing a challenge with aligning the payment of Objectives Bonus in our model with the anniversary dates of employee entries. The requirement is to pay the bonus on the anniversary date of each employee's entry, but our model calendar is based on the years 2023 and 2024. The issue…
-
End date that should be a working day only
We want to get the End date but it should only fall on the weekday, we have tried other workarounds but it didn't work as intended. See screenshots fyr. END DATE (working days only) = START DATE + Duration Days we also have a module to count the weekends and holidays so to get the END DATE (working days only) END DATE…
-
Smaller Time Range | Less than a year Time Range | Day granularity
Anaplanners, I would like to have a time range in a granularity for less than a year. Somewhere between a month or a Quarter. We have a business requirement where we have to import and export working hours for each user per project per DAY. This activity will be monthly and may not be necessary to have more than a month,…
-
Dependent dropdowns doesn't worked
Hello everyone, I'm asking some help. I have a numbered list "CA0" : This list has two propreties : I want to use the propertie "CA2" in a dropdown list. Here is an example. I create a moudle with two line items : CA0 and CA2 The CA0 line item is formatted like that : Here is the result, I have all my list : Can you tell…
-
Version of PREVIOUS that works ad infinitum?
For actuals months I am calculating a 3 month moving average of percentages across several dimensions. For forecast months I want to repeat the results from the final month of actuals all the way to the end of my time range. Is there a formula for this? It seems that PREVIOUS should do this but it is only returning the…