-
Select first week of the time scale by user
Hi, Current I have designed like this to select first week of the time scale. But I am wondering is there a way in ANAPLAN That If I select one check box for that Line ITEM, it will disable all other check boxes for that same Line ITEM and If I uncheck it , it will enable all other check boxes? Here I have maintained a…
-
Reconciliate when having subsidiary views for fx rate
Hi, I have an actuals module that has all transactional data from the actuals in local currency. In there I created a line item, Amount FX, that has a subsidiary view since it has the FX Rate dimension added to it so it can do the FX rate conversion on the line item Amount. The numbers in the import are validated so they…
-
Import from a module with multiple list members
Hi, I am trying to import from a source module applying to a scenario list, to a target module that is independent of this list. Can I select which scenario to import from? I know that if it is the opposite, i.e. importing from a module without the scenario list to a module with scenario list, it can be set as "ask which…
-
Level 3 Live Instructor Led Training Option
Dear All, We we have such training for Level 3 ? Thank you, Lily
-
Personal Anaplan Workspace
Hi All, Is there any way in which single users can obtain an Anaplan workspace for the building out small personal models? Thanks, Chris
-
Control Time Period drop down selections
Hi Anaplanner, I have a scenario where the time period(year) should be selected from the dropdown for a line item. The model calendar holds 9 years and a time range holds 3 years. I require the dropdown to show only the years included in the time range. Is there any way to setup a dependent dropdown and not by creating…
-
Rolling Allocation Problem
Hello Gurus, We have an allocation problem. We have Shortages(Demand) and Supply by month. We have to allocate the oldest supply to the demand ie FIFO. Also, there is an expiry period for the supply, beyond which it cannot be allocated. The same is illustrated in this example, you may note there is a 1-many, many-1 and…
-
Highlight Duplicate rows including first one
Hi All, I have a requirement to highlight rows with duplicate line items in a Module. I have tried using the ISFIRSTOCCURRENCE along with conditional formatting but was only able to highlight the 2nd duplicate row. I am using Concatenation to check duplicates within a unique key of 4 line items. Would be great if someone…
-
Count Duplicates Based on Text Field
Hello! I'm running into a problem that I'm struggling to solve and was hoping that I could get some help here. I have a numbered list that represents employees. Sometimes, employees are converted from part-time to full-time and when this happens, they are assigned a new employee ID. I need to be able to identify cases…
-
Formula scope - actual version
Hi I have a module where the formula scope is currently showing "actual version", where if time is less than switchover or isactualversion(), then it picks up actuals. I've tried to drill down, but I can't see which module actuals is coming from? Anapedia is quite vague and unhelpful. Can someone please explain? Thanks
-
DEMO 03 Baseline Forecast showing zero's for FY21
DEMO03 Baseline Forecast module showing zero's for FY21 I have used four more formula's along with the shown in this image. Formula 1 : IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' then OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) else IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' then OFFSET(Default…
-
2.3 DAT03 Historic Volumes
Hi, I have historic figures for volume in DAT03 for FY19 that have been offset to give me baseline forecast for FY20. How do I achieve the same for baseline forecast in FY21 as currently my baseline demand ends at Dec 2020. I also cannot seem to enter the ROUND formula correctly in DEM03 to get the Initial Demand Forecast?…
-
Break Back
How can we apply break back to the line item that is having filter, for example I have one list with list items 1,2,3,4. In a module I will use this list as a dimension and will apply filter which will show only 1,2. now if i enter a value on parent then it has to split between 1 and 2, but it is happening like splitting…
-
How best to create a variance module from a revenue module with a version dimension
Hi I need some help on this. I have created a revenue module with a version dimension for actual and forecast. The variance is a simple calculation of difference between the two. The issue I have is since the actual and forecast revenues are sitting in dimensions rather than line items, how does once calculate the…
-
Breakback on List items
Hi All, I have a list product list P4 and a filter is applied on it i.e at P4 level only few items should be shown based on selection. Break back is enabled on all levels. In P4 5 items are there only 2 items belongs to category 1 and 3 items to category 2. Our requirement is that If user select Category 1 and enter data…
-
How to get only one value from a module that contains Time
I want to get only one value from another module without having a list. The ideal is to display the value of the first month of a module with Time in another module that has no list. I am not good at English and it may be difficult to understand. Thank you.
-
Question on aggregations
I have a module with 4 dimensions - Version, Countries, Projects and Employees. Single line item is worked hours. Hours at employee, project and individual country level correct but not when aggregated at All Countries - the numbers don't look right, why? The aggregations seem fine at individual country level but not when…
-
FIND formula not working
Hello, We have an line item composed of all the Sales Reps associated with an account (some only have 1, some have multiple). This line item is text formatted. This line items is called "Sales Reps" We then have a second text-formatted line item, which is a text field, called "name," and the functionality we are looking…
-
Formula questions
Hi, I'm attempting to write a formula to pull in the percentage amounts of a line item in a different model in accordance to a certain vintage year. I'm trying to use either the LOOKUP or SELECT function but getting a error. Please advise. 'R01 Inputs'.Funding Scaler[LOOKUP:Vintage] Thank you
-
Level 2 Sprint 2 Forecast cf formula
I have been struggling with my formulas and I just wanted to check that my Forecast cf formula was correct. It worked the first time which made me nervous. The instructions are: * If Initial Demand Forecast is EQUAL to the Final Forecast, set value of Forecast cf to 0. * If Initial Demand Forecast is NOT EQUAL to the Final…