-
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!
-
Referencing a property of a parent list in a list item
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 = Parent(SKU).Tax Property Please provide an example on how to accomplish.
-
Using OFFSET to retrieve prior period data from another module
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 source and same target), the function works. What am I doing wrong? This Works in Module 2, Line Item Calc OFFSET(Entry,-12,0)…
-
Start Period less Date Now?
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!
-
Avoiding circular reference in Custom Time Dimension List
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 Backlog of Current period". Is there a way to solve this problem without using the Native Time Dimension / formulas ? "PS- I have…
-
Last work day of month
Dear all, is there a function enabling to show the last work day (ending on Friday) of each month (date formatted), e.g. last work day of July 2016 would be 29/07/2016? Thanks a lot in advance for your feedback. Best regards Timo
-
Numbered Lists and filtering
Hi, I have created a numbered list with list formatted properties. When using such a list in a module or dashboard, is it possible to filter based on these properties? Thanks Roger
-
Select and Lookup by Display name
Is there a way to use lookup by display name? I have a numbered list List B which has parent hierarchy is set to List A I have set the display name instead of the code. Module 1 : Pivot has: Pages : Line Items Columns: Country list, Sales list Rows: Storename List LineItem: Salesinfo Country Total Sales- toys Total sales-…
-
User full name in formulas
How do I get the full name of the user in formulas? I have a module with owner data and i want to check if the logged in user is the owner of the data eg: I have a property called "Primary Owner" I want to check if the logged in user is the primary owner of opportunity data. Instead of hardcoding the owner name I want to…
-
Bulk Copy
Hello All, I am trying to do a 'bulk copy' action to copy data from Actual to another version. However, even after I select the target version, the "OK" button is still greyed out. What might be the reason for this? I am the workspace administrator, so I am assuming that I have full (write) access. Please provide your…
-
COUNTIF Type of Function in Anaplan?
Hello, I am trying to figure out if there's a COUNTIF type of function that can be used in Anaplan. I have a line item that lists various years in number formatting and need to know, for example, how many times 1988 is shown throughout that module. Any help is greatly appreciated! Best, Chase Cantwell
-
How to Calculate Days Difference between Two Dates
Does anyone know how to calculate the difference of days between two days? For example, (4/1/2015) - (4/5/2015) = 4 Thanks!
-
How to get COUNTIF type of formula in Anaplan
I was looking to count a list property text and come up with a numerical value total. In excel we can use countif, what can i use here in Anaplan?
-
How to map a line item into a dimension
Hello, below my issue. I have a Module Product_FollowUp with product list and Time as dimension of this module. Inside the module, i have a line item "Assigned Resources" based on a list of Resources and others line item with number (ie : "Validation Done"). The Ressources is not a dimension of this module. I need a Module…
-
Error in Formula in Rep quota module
Hi , Can any one please help me with the following formulas used in Rep Quota Moduel: Tenure Formula: IF NOT Active? THEN 0 ELSE IF YEAR(START()) ‐ YEAR(REPSETUP.Start Date) = 0 THEN MONTH(START()) ‐ MONTH(REPSETUP.Start Date) + 1 ELSE 12 ‐ MONTH(REP SETUP.Start Date) + (YEAR(START()) ‐ YEAR(REP SETUP.Start Date)) * 12‐…
-
Unique Count in Summary
How do you write a formula that takes the UNIQUE count of values in the summary. For example: Product A: Rep 1 and Rep 2, Total = 2 Product B: Rep 2 and Rep 3, Total = 2 Product C: Rep 4, Total = 1 At the summary level for all products, the count of reps would be 5 however, the count of unique reps is 4. How can you get…
-
Timescale related formulas
I have update the list with fake time periods, how do I use the timescale related formulae like next/previous etc in the module? cheers,ym
-
How to use Time Period Format in a Date Formula
The date formula requires you to use numbers for the years, months, and days. I have 2 line items in a module that have the year, and a custom month list that contains the members of Jan, feb, mar, etc... For the month, I have a property on that list with the month number, so I can easily pull that into the date formula,…
-
Day of Week
I'm trying to find a "day of week" function. Essentially i don't want to count hours on the weekend. Any ideas? It seems like it should just be a formula dayofweek(start()) but i can't find anything like that. Cheers, H
-
need SUBTOTAL across Time
In several cases I need to use a subtotal for 5 quarters in calculations. I have been using the All Periods total for most and it works some of the time. However, often I don't want values included from previous years. Ideally there would be a function like SUBTOTAL in Excel where the total would only be for the columns…
-
IF CONDITIONAL FORMULAE
Dear Anaplanners: I have a question regarding usage of IF conditional statement. All the conditional constructs in Anaplan are related to IF with ELSE as a mandatory clause. However, I have following requirement - 1. I need to chnage the contents of cell A only when condition_A is satisfied. Otherwise, I do not want the…
-
How to sum with filtering data
I have some data as per below table. RevenueCountryNew bizJanFebRev aChinaY 3,000.00 3,000.00Rev bHong KongN 2,000.00 3,000.00Rev cChinaN 4,000.00 5,000.00Rev dHong KongN 2,000.00 4,000.00 I would like to sum the revenue by country and month as well as filter out the new biz = Y. Answer: China: Jan revenue = 4000 and Feb =…