I am looking for a correct formula where, in a destination module, if I do a time selection on a specific month I get the periodic value and the ytd value of that month and the previous month. But in …
Hello All I have come across the following error ... while importing data in to a LIST _Error_1_New property combination found but name or code already exists Now i have been to the source file and do…
Hi I am looking for a forumula that converts the year and week number in to a date format Example - 2015.01 converted to 1.01.2015 What could be the formula for this Thanks
I have a line item with a list format where the items contains some parents. Eg. List contains Parent: Sector A with Child Material A, Material B and Material C Parent: Sector B with Child Material D,…
Hi, I'm new here and I'm not that experienced yet with Anaplan. My problem: I've created 2 lists. Prof_level5 tells me if it's a mortgage loans, consumer loan, professional loan or defaulted loan. Pro…
I am trying to use a lookup based on month to return versions. We have 12 versions one for each month in the current year. I was thinking I would create a mapping table with months as a dimension and …
hi, I'm trying to find out the function that updates numbers on row automatically week by week. What I expect is that, from attached capture, if I put numbers on "customer request" on week1, then the …
Good afternoon- I have a question for a customer asking that instead of overwriting forecast with actuals they would like to have forecast values populate Actuals when the switchover happens. Long sto…
Hi, Background I’ve a CSV file, 300K to 400K lines, with 3 fields, “Salesperson”, “OrderID” and “OrderAmt”. This file is loaded into a list, “List_Orders”, which in turn drives a module “Module_Orders…
Good afternoon, I recently worked with the IF ITEM(Hierarchy) = Hierachy.HierachyItem THEN ... ELSE ... to aggregate calculation modules. Currently I want to do the same for the different calculations…
Hi, I have a module in which variance calculations are executed on 2 static versions. However, I'd like to set up a variance module in which the user can select two versions from a list of versions to…
Hello, I'm currently working on a module, where one of the Rate list items is a difference of the other two, indicated in bold. The problem that occurs here is that I receive a circular reference erro…
Hello, I'm tring to detect 1st date by per item(ex parts) with some condition. ex) Parts Inventory module (appling parts list, time) PartsLineitem1-Aug2-Aug3-Aug4-AugAInventory1010-1020BInventory-20-2…
Hi, I am trying to use Collect() function to collect a value on a particular version by using Line Item Subset ,but it is only collecting a value from only one version to other versions. Please sugges…
Hello Everyone, I am new to Anaplan and I was wondering if there is a way to sum rows but not the Summary of them. For example in the module, in the rows I have the Employees List and in the Columns I…
Hi all, I have a module with a single multi-level list (category, subcategory, product). The 'all' level is called 'All Products' I need 'weight to parent' and a 'weight to all' line item formulas to …
I am using a numbered list as the dimension for a transaction log which stores changes to a people count line item applying to 7 dimensions (list items). The numbered list has each of the 7 list items…
Is there any method of multiple access control for 1 item? ex. Supplier List (with selective access) Supplier A Supplier B Plant List (with selective access) Plant X Plant Y Item List Plant(Property)S…
Is there a way to display across in a module, the "Properties" field names from a numbered list? In the list below there are four property fields I'd like to display across in a module in the "rows" …
Is there a way to use a formula to calculate the value your are inputting into the cell? For example, if I'm loading a forecast and am inputting the forecast value for a specific month, I'm looking fo…
I have a module which applied to a Numbered list. I have applied Top Level and Parent Hierachy to thist list. However in the module, Top Level total doesn't sum up the amount in the list, in fact it d…
My Fin Year item is set to Time Period format: "Year". Our financial year setting is April to March. Attached is the Anaplan example and my working model that seems to return different result. I would…
I have the below requirement on user-based security access at the node level. I have 3 nodes (L1, L2, and L3) For example If L1= Americas L2 = Canada and US_Disti L1 and L2 will be my composite lists …
Hello, I am having an issue with IF THEN ELSE forumla syntax. I have the following fuctioning forumla, in the context of converting weeks to months. IF Start Difference <= -23 AND Start Difference >= …
I have the issue to change the line item format from 1,000,000 to 1,000 k. It's clear how to add "k", but how decrease the value to 1,000 without dividing? I mean it will be great to find the way how …
Need to reference the property of a Parent list in a list item of a module Example Module: Deals List Item: SKU Tax Lists: SKU (Child), Product (Parent) Desired outcome: function: Deals.SKU Tax = Pare…
Hello, I am attempting to retrieve prior period data from module 1 to module 2 and cannot seem to get the OFFSET function to work. However, when I use OFFSET to retrieve data from module 2 (same sourc…
Hi! How can I get the difference between two time periods that will result in an absolute number? For example, 10/21/2013 less (the current date) 04/26/2016 = 30? Thank you!
Hi Guys, I am using a custom time dimension list in a module as shown below. I am getting circular reference error when I try to fetch the "Ending Backlog of previous Period" into the "Begining Backlo…
