
Modeling
Modeling
Discussion List
- Hi, PLease see details in the attachment. Regards,
- Hi Can someone advise, please? I created a subset for E2 employees, as instructed in the video. I went to E2 employees - subsets tab and created it. In the next section the course says to check if I h…
- Hello, I have just done the Optimizer exercises Optimizer: Exercise Walkthrough created by @mark_godfrey , and have an error in the Production Optimization Exercises example. While its possible I mess…
- This request has been posted already in 2013 & 2018 and probably in the years in between. It is not availbale yet, while it will solve a lot of problems for many of our customers. If you do not want t…
- After completing model building activities, we need to prepare the model for User Acceptance Testing, one of the requirements is "Review and organize the Actions to rename and add repeatable actions t…
- Hi guys I am trying to figure out how to populate the shipping time weeks line item from shipping method and the shipping metircs module. I know there is a level mismatch and so I created a staging it…
- Hi all, I need to replicate the formula from excel of NPV. I've months of first year that sum up to a Year followed by 4 years. Below is the structure of module. Line items are in version dimension - …
- Hi All, I am facing a strange issue in Anaplan. Hoping someone can help me with this. I have a calculated % field called 'Calc %' The formal this field is set to 2 decimal points and percentage. I hav…
- I have a 4-4-5 Weekly Model. Details below Time Scale I wanted to get the exact month for a particular date. Details below Formula? Period(Valid from) for 5/31/2020 is giving the month as Jun 20 and n…
- Hi All, Please see attachment for details. My apologies my post encountered an error so I have to attach the details Regards,
- Hi All, I would like to ask for some insights with a Circular Reference Issue. Here are the details So we have a dimension Unit Mix, where the TOTAL is the Top Level and Parking and Total/ Average is …
- Hi all, I am building a dashboard for the finance leads to comment on the Operational Variance for every chart of account. (see attached) They need to comment on the Op. Var. for the current period, f…
- Hi there, I need to change some modules that are referencing "C5" to C4. C4 is the parent of C5. What is the best way to change the dimensionality and format of modules that contain "C5" without losin…
- Can someone please guide me. I have each SKU and would like to get total count and standard deviation. I can get sum but for 7months of data how can I get total count and standard dev?
- Hi Does anybody have an answer to building a list hierarchy with a child with multiple parents? For instance, when an entity is owned by multiple 5 trusts equally 20% each, how can we possibly build u…
- Hi All, My model Calendar is 4-4-5. So Dec 30-12-2019 is falling on Jan Month. I want to get Jan month 31 days, Feb - 29( and Feb 2021-28 days), march -31 days,apr -30 days..and so on. The Model calen…
- Hi, I have got a requirement of having my Actuals in Qtrs, Forecast for the year, Budget- Budget formation in Q3, Budget validation in Q4, Budget Figure 1 in Q1 of next year. Please suggest if I need …
- Hi Team, I'm creating a Time Map module for Time Dimension - Months for a Model Calendar with Weeks with Half-Year Totals selectred The 1st Line Item in my Time Map is ITEM(TIME) which Time Period - M…
- Hi all, I have a challenge and I am searching for the best solution. I have (a lot of) sales data and I am using that data to forecast on a daily level for the coming weeks. National holidays have a h…
- Hello I am trying to create a profile to spread revenues by client (i.e. When a client signs a contract in the future, when will the revenues occur based on past performance. First I have a module tha…
- Do we have a replace function? I want to change a value.
- Dear Friends, I need some help from you. I want to update my list. My initial list items (12 list items), will be renamed and a new list will created with the (4 list items).
- Hi Friends, I am struck with a difficult situation. I have Module 1 and this is the Data Hub and the Date is stored in Text Format. Every quarter I need to pull the data and make it look like Module 2…
- Hi Friends, I want to create an Action process. That will automatically import the current year data. Please assist me in this.