Hello Experts, I'd like to obtain start month of a fiscal year. What I have now is current fiscal year in number format. And what I want to do is to compare item(time) and start month of a fiscal year…
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, if the model contains an unused views, and i would like to delete the views to make it more maintainable. Is there a good procedure for making like this list? moduleX - View1 - used in dashboadA m…
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 Anaplanners, i am working to meet a certain requirement ,wherein cost incurred in transferring goods from one country to another(referred to as a Flow) needs to be auto captured based on the first …
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 am trying to limit the options in a dropdown list so that a user cannot select "option A" for both "slot 1" and "slot 2". In the attached image, the equivalent would be blocking the user from assign…
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, 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 …
While formating the line item in REV02 volume inputs module how to set as default, is it means whatever setting was there for setting by default should go by that? But then the OK tab is disabled if I…
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! I learned that when Switchover is enabled by selecting a time period from the dropdown list, Anaplan will merge data from the Actual version prior to the Switchover period with data from the Forec…
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…
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…
