-
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?…
-
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…
-
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…
-
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
-
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.
-
Inventory Ordering Module Formulas
Hello everyone Why training course think that it is wrong formula? Confirmed Purchase Order Receipt (INV01 Inventory Ordering) IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0
-
Child and Parent mixed level formula
We've come up against an issue we're struggling to resolve. The situation is we have 1 Parent and 2 Children. We have the TotalStaff at the Parent level. Child 1 is prioritised and may require 60 of the staff to meet its SLAs - this is determined in a second line item. What we would like to do is be able to calculate the…
-
Summary Method - Multiply/Product
Hi all, I currently have one line item with 2 dimensions, and the numbers are percentages. I essentially want to strip out one of the dimensions in a new line item but to have all the percentages multiply by each other for the dimension that was taken out. In simple terms, I'm looking for a 'Summary Method' that multiplies…
-
Inputting a formula based on range of dates
Hi All, I'm fairly new to Anaplan and have a module that gets start period and end period. What I want to do is use these time range in order to set a specific amount based on a formula. I want to apply a specific formula on the time periods with respect to the start period and end period. To give an example, in one cost…
-
Rounding issue
Hello, I'm having an issue in which a sum of rounded items is still showing some unexpected decimals. See screenshot below. Is there a workaround for this other than using formula as the summary method? Thanks, Josh
-
Error Message
Hi, I have a error message that keeps on popping up when I'm trying to create a formula. Please advice. Image is attached. Thank you
-
Summarize Boolean
Hi there, Module 1 has a model calendar, and module 2 doesn't use it. The model calendar has two future years & past years. I wanted to summarize the boolean of Module 1 in Module 2. I didn't get the expected result when I was implementing ANY & TIMESUM functions. Please advise me. Thanks,
-
Importing Multiple Rows based on a Quantity Value based Cell?
Hi Everyone, I was wondering if anyone knows or has experience creating duplicates of an Input Row and all of it's associated components based on a quantity line item? For example, if I wanted to create 5 new employees that will have the same salary and reside in the same state and cost center. Is there any techniques that…
-
Smart Filter not working in NUX
Hello, We have a dashboard which features a smart filter for sales rep. When you select a name from the smart filter, the corresponding grid's selector only holds the accounts owned by that rep. This functionality is fully operational in the classic dashboard. However, when we imported that classic dashboard into the New…
-
Creating Formula Question
Hi, Would like to know how to create a Formula with the following structure for a Line Item (1). Closing Balance of Line Item (2) as of the end of the month, and this will show/happen only on the 10th of every month. My attempt END(Line Item (1) OFFSET( Closing Balance of Line Item (2), ?, ?) Please advise, Thank you
-
Formula
HI, Have a module with assets and time dimension, some of the assets starts from the middle of the year. when on selection of total assets, The "No of payments" lineitem not showing sequential numbers and anaplan is not accepting(ss for the same) the "formula" summary . Below is the formula for No of Payments = IF…
-
Calculations using list items within a line items?
I have a line item that needs to reference one of the list items instead of a line item. What does this mean? I have a list of staffing types that use a model configuration to calculate based on what the user selects. Each staff type is mapped, then calculated off the drop selections the user picks. The main one is the…
-
Circular reference
hi, have 3 lineitem, a, b,c wherein c= a+b, a = previous(c), b= a*rate of interest, But, however, getting a circular reference when writing a formula in the lineitem "b". Below is the screenshot of the explination, Any help is highly appreciated.
-
sumif excel equivalent
Hi, I'm stuck on a sum select formula ?? Circuit Pull.Project[SELECT:Projects.X, SUM: Circuit Pull.Range] ?? Essentially what I'm looking for is to hard code a specific project below, project 2 but I can't figure it out in anaplan. Thanks in advance!!!
-
source and targert modules are dimensioned by two different dimensions
How can we link these EMP02 and REP04 modules to get total car costs by the region and role. When I am using formula i.e car costs = emp02 .carcosts[lookup: sys08.region, lookup.sys08.role] it is throwing folowing error. I under stand my REP04 is dimensioned by Region and Role where source module Emp drivers dimension by…
-
Creating formula question
Hi, How would I create a formula that would give me the number of days in a given month?
-
Current page Context for page filters
I have a module with a list-1 in rows list-2 in columns list-3 in pages list-4 in pages. The dropdown for list-4 is dependent on item selection from list-3 and vice versa. Filters are created for that but when applied, I couldn't see the option of Current context. Alternative work around could be creating hierarchical…
-
Way to limit or not allow user to select a specific time period in the dropdown
Hi, I have a line item Start and End that has a list of 1-5 as shown on the screenshot below. In the example below for item 1, I have selected start and end date of Jan 19- Mar 19, in item 2 I have selected Apr 19 - Jun 19. Is there a way to limit the dropdown of the second item so that it will not allow me to select a…
-
Get Total Value on another Line Item
Hi, Please help how can I get the total value of another line item to the other. Pls see attached screenshot where I tried to use lookup of the parent hierarchy to get the total value but it is not picking the correct value. Thanks in advance, Tom
-
Search an item in Module in a specific range
* Module dimension: Department, Country * Line item: User Name. (Formatted with a fake User List) I'd like to get all unique User Names from a specific Department 'ABC' and ALL Countries, with these unique user names, I'll able to build a list. I tried to create a subsidiary view in the module, dimensioned with fake User…
-
Lookup Demo App
While seeing the Level 1 training, I came up with the LOOKUP demo app. But I couldn't locate it in the app hub. Where can I download it?
-
Extracting text field from transactional data load module
I have a question regarding pulling a text-formatted field (e.g., a status entry that could be but currently is not list-formatted) from a large transactional data load module that consists of CSV-imported line items and then various data mappings to lists, numbers, etc. and some RANK and MAX cleverness to focus in on the…
-
Sort function missing "OK" button
Hello, I am trying to complete Activity 12.4.6 in Module 12 of Level 1 Model Building, but my sort function is missing the OK button to implement by sort. I've tried restarting my browser and computer, but no luck. Has anyone else run into this issue?
-
Line Item:Confirmed PO Delivery Sprint 3
Hi, Would like to know if this is the correct formula for the Line Item:Confirmed PO Delivery in Module INV01. If not please give me some guidance. OFFSET('PO(Purchase Order) Submitted', Shipping Time Weeks, 0) or should I use POST(PO Submitted, Shipping Time Weeks) Thank you
-
Level 2 - Sprint 2 : Update Historic Volumes
Hello, I am stuck at step:2.3.9.2 Update Historic Volumes for Baseline Forecast I can't deduce the formula for "Offset Volumes for 1st Forecast Year" because I don't know the formula of "1st Forecast Year?" Would you please know the formula for "1st Forecast Year?" Could you help me please Thank you