Calculation Functions
Discussion List
-
How to give selective access to Drill Down Function
Hello, Anaplanner 🙂 I'm conducting the implementation of ANPLAN. In this project, Many companies give their data (ex: Purchase order, Reply order, Inventory etc) to one ANAPLAN model. We collect the detail data and make dashboard by combining that. so we have to give selective access to each companies. (See Attach)I thiink…
-
Get prev year result
I'm quite new to Anaplan and I would like to know if this formula is possible instead of IF Current Month THEN Variable Name[SELECT: TIME.'Nov 15'] this IF Current Month THEN Variable Name[SELECT: TIME.'ADDMONTHS(CurrentPeriod,-12)'] Is it possivle and am I using the correct syntax. Chris
-
historisation of data
My client wishs to backup data and not loose it when the time periods change. To do this I envisage modules with not applicable time and containing 2 lists: one the months of the year, the other the sequential years that he wishs to save. My difficulty is to transfer the data to these modules. In the source modules, in the…
-
Transaction Roll Forward on a Custom List
Transaction Roll Forward on a Custom List
-
Formula for comparison of previous quarters and months
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 the same line item the formula should hold when I select a quarter. So when selecting a quarter it should give me the…
-
Error Loading Data
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 done checks multiple time to see if there was any duplicates but there were none. I see this error as a there being…
-
Delta Loads
Hello Is Delta loads possible for BOMs data in Anaplan and if so what is the best way... Thanks
-
Date Conversion
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
-
Not a Parent function?
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, Material E I want to either 1) allow the selection to excludes any parent items, (Select Only Material A, Material B,…
-
Refer to Parent list
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. Prof_level6 is a drill down of level 5, it contains for example more detail on the professional loans saying if it's an immo…
-
Format Line Item as Versions
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 format a line item as version to use a lookup. Is it possible to format a line item as versions. If not, any other…
-
Weekly Auto-Number Updating
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 numbers will move to "prev. customer request" automatically a week after. If anyone knows about this kind of function,…
-
Populating Actuals with Forecasted Data
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 story short is they do all of their adustments in forecast and would like to have the forecasted values populate actuals when…
-
Formula in list or module
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”. “Module_Orders” is 2-dimensional, with “List_Orders” in the columns field and line items in the rows field. It’s used to…
-
ITEM(Versions) : Versions is not recognized as a hierarchy in the model
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 I made regarding actuals, forecasts, budgets on bases of input files. However, when using the formula: IF ITEM(Versions) =…
-
User selected version comparison
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 be used in the calculation. I've set up a 'Budget Selector' module with 2 line items (Budget #1 & Budget #2) and have tried…
-
Circular reference: SELECT function
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 error, because I'm changing the line item 'Prepay (Partial)'. However it would never circular refer to itself, because of the IF…
-
How to detect with 1st date with condition
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-20-200CInventory102030-10 I want detect 1st negative date by each item, desireble result is as follows 1st shortage date…
-
How to use collect function on a particular version?
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 suggest . Thanks in advance ....
-
SUM Rows and not the Summary
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 have the Line Items and under these the Business Units Abbreviation List. In the Business Units Allocation Line Item it…
-
Ratio to all & Ratio to parent within a list
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 use in my calculations. It's coming unstuck when i try to look up the 'denominator' for the weight calc. eg the value of the…
-
Querying a Transaction log
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 as a property (format type list attached to the appropriate list item). I want to populate a line item that has been…
-
How to multiple access control for 1 item
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)Supplier(Property) Item1Plant XSupplier A Item2Plant XSupplier B Item3Plant YSupplier A Item4Plant YSupplier B User Settings…
-
Display Properties from a Numbered List
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" section where currently there is just one column - first row is "Virus Protect."
-
Formula for entering value
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 for the ability to say that value should be =2+3 instead of having to key in 5 as a simplistic example. Otherwise if I have…
-
Top Level of Numbered List
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 doesn't show anything. is this a bug?
-
YEAR() function not working
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 expect that in calendar month/year, May 2016, that the Financial Year time period would say FY17 (appears that is the…
-
User-based security access at the node level
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 and we will have various attributes (KPIs) attached to them like Bookings or Sale proceeds etc. Now, If I am looking for…
-
If THEN ELSE syntax
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 >= -28 AND End Difference >= 7 THEN ITEM(Week) ELSE BLANK I am trying to add a condition that says if the week start date is a…
-
Thousand format
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 to change format, but not change the value. Thanks!
Upcoming Events
-
Unlocking the Value of Community with Anaplan Community Bosses
Join us for an exclusive professional development roundtable designed to celebrate, connect, and elevate our premier platform advocates: the Anaplan Community Bosses. The Community Boss program stands at the very heart of our ecosystem, highlighting leaders who dedicate their time to guiding peer model builders and…
-
Designing for Fit, Utility, and Practical Guardrails with AnaplanXL
Join Anaplan experts for a practical introduction to AnaplanXL (AXL), the Excel add-in that connects Excel grids directly to governed Anaplan data. As the first session in our technical series, this event is designed to help: Model Builders understand the fundamental purpose of AXL: what AXL does, the basic guardrails for…