Hi Is it possible to publish input cells from a module to a dashboard, and have it not be able to be edited on that dashboard only? For instance, there are some input cells on a module which feeds a d…
Hi to everyone, Probably someone can help with these 2 issues: 1. when you place a module with many columns on the dashboard (so you have to scroll to view the whole table) and need to fill it with nu…
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 you…
Hi, I have got stuck in certain formulas. So decided to start this thread so that those who get stuck, can view the formulas here. I wanted to know formula for Headcount in Rep-Quota module for interm…
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
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 : L…
Hi everyone…. I have three modules 1. Transaction module (Base Module with flat data) 2. Secondary module 3. Result module. Can I ‘drill down to transaction’ from result module which is getting the va…
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 wa…
For strategic planning, our executive team has a need for a 3-5 yr plan which they can tweak/adjust on the fly. For example, setting broad goals (x% revenue growth, y% gross margin, etc.), which would…
We have a scenario wherein the organization hierarchy is as follows [list=1] * Legal Entity * Units * Departments * Employees Where the departments gets rolled up to the units and in turn units gets r…
Hi, We are not able to copy a module from Model A to another model B. We've tried importing the module option, but its not working properly. We tried mapping data fields and running import but it was …
Hi Folks, I have two list( Product and Customer) Product in Row Axis(Its member are P1 to P100) and customer(Its member are C1 to C20) in Column Axis. If I select C1 then product list will get reduced…
I am quite new to model building and a client has come across trying to pull data from one specific cell to another specific cell from two different modules. Based on the training i have gotten it mos…
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 r…
Hi all, I would like to ask a question regarding Current Version. If we have an entry module with no formula and no version applied to it, is there a difference if in the Formula Scope All Versions or…
For a client I am building a planning model. Part of the model is that the model itself is attrackting funding based on a minimum cash level. Due to the fact the new funding generates cash in that spe…
How to delete data uploaded from excel, from a list, without deleting the list. I have to delete the list again and again, whenever I upload the data incorrectly.
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 …
I’m new to Anaplan, doing my model builder training.I wanted to know, when I copy a module, if I want to change the dimensions applicable to that module how I can do that?I think I’ve found one way – …
Hi everyone, I need your support regarding the restore function. Indeed, I have a model with 2Go which contains the data of 2014 and 2015. To reduce the occupied disk space I deleted the data of 2014.…
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 …
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()) ‐ …
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…
