-
Summary Method Problem
Hi all I'm having some weird numbers on month over month rate calculation that I did. I tried to use Formula for the summary method but it throws me this error below:- I'm not sure if the issue lies in the formula or the summary method. With calculations like this using PREVIOUS() what is the best summary method to use.
-
Can I add multiple lines of data to a MAILTO link?
I have several links to create an email for me based on highlighting a line of data and that pushes data from each of the fields into specific places in the body of my email. What about if I select multiple lines of data? Can I add all of those lines? Can I add a saved view of selected data to a MAILTO? Hope you can help…
-
remove double counting of projects
Anaplanners, I have a query on how i can remove double counting of Projects. Case artifacts: T1 Teams, which is a hierarchical list, so for example Team A.1 & Team A.2 rolls up to Team A, like wise Team B.1 rolls up to Team B; all rolling up to total teams. M1 Members: Flat member list. P1 Projects: a Numbered list of…
-
List Update Notification
Hi all, I was wondering if there is a way to notify the user each time a list is updated. In my case, there is a list named "cost elements" whose list items might change; the user checks the boolean of the list items belonging to the subset he is supposed to use. It would be nice to add an alert, maybe a KPI, every time…
-
DYNAMIC DISPLAY NAME FOR FORECAST MONTHS
Hi, I'm currently working on a project on which each entity needs to input their forecast for the current and the two following months each month. In the input module, in addition to time dimension and the list of the entities, i created a new list with three items : M M+1 M+2 to store the data each month. However on the…
-
Remove Limit for List Reset Index
Hello Everyone, I saw a new update that user can reset the list index and allows users the discretion to reset their lists at any point on the basis the list is empty. But this "Reset" option is disabled for me. Can anyone suggest when is this "Reset" option is enabled? Many Thanks!
-
Full access role can't run an action
Hi, a user with the role Full Access needs to be able to run a process, when going to Users then within the Roles—>Action tab I can not see the Full Access Role to provide the access to all actions included in the process. The action brings data from our data hub into the model. Note: I should not provide Workspace…
-
How OFFSET operates? Please explain with examples.
-
ISFIRSTOCCURENCE() issue in model when more users are added.
Hi Everyone, I added 1 user into my system and as soon as I run one process, it is failing to say that "Too many cells for ISFIRSTOCCURENCE calculation: actual =50000094 maximum=50000000". But as I remove 1 user from the users tab the process starts running fine again. I am a little bit confused about why this kind of…
-
Time based IRR Calculation
Hi All, I've list of transactions and data is day wise. I need to calculate IRR on time basis . I want calculate IRR on day basis and at the end the summarized level IRR i.e Quarterly, Yearly. Also I want to calculate Asset wise and fund wise IRR. Can anyone have idea about how to do it? For your reference please find the…
-
Not able to run the 'Create' action
There are Create actions in my model, whenever I click on any of 'Create' action, this Run button gets disabled automatically for all Create actions, however I am able to run Import , Export actions of this model. I am Workspace Administrator and have full access to the model. Please suggest if I am missing some access…
-
Summary method - Ration to Sum
Hello community, is there any possibility in anaplan to retrieve data from line item defined on ratio on summary method[As source] to line item with sum in summary method [target]? Any help or suggestion? Thank you
-
Use combined lists ou other parent child relation?
[Context Demand Planning for school books] I have 5 lists: SKU (Book) - e.g:5858595 Subject - e.g. Maths School Year - e.g 5º Grade Type of Subject (Mandatory/Not Mandatory) Theoretically, each subject has two parents: The type of subject and the school year. Since it is not possible I thought of 2 possible designs: A…
-
MAPPING
I have a module with dimension x and I want to get a line item y from another module with dimension z . How can I achieve this in anaplan? I am unable to use direct lookup modules
-
Activity: Prepare Data Exports
Hello, I'm not sure why the shipping cost line item is showing 0. Below are the instructions followed and formula used in the module: INV01 Inventory Ordering reference: Thank you so much in advance!
-
I want a formula for Boolean line item as true for below requirement. How to do that?
.
-
How to calculate response target time and Resolution target time
Hello, I'm trying to calculate the Reponse target time and Resolution target time for a request by the end user. In that module I already have: Creation date, format Date → the day when end user will raise the request → will be filled manually Creation hour, format number → the time when end user will raise the request →→…
-
Circular Reference Issue
Hi Anaplan, Is there a workaround on circular reference issue?. I'm doing a calculation on the Profit Line Item which is: But am getting a circular reference when adding the VOD Cost line item in the formula. The VOD Cost line item references also the VOD Revenue line item, which I've screenshot below. Is there a…
-
Anaplan Percentage Format Issue
Hi All, I am trying to calculate the Compound annual growth rate (CAGR) in Anaplan and I am getting a 100% instead of 1%. Here is the formula logic in excel =((Z84/C84)^(1/23)-1) The first value is cell=(C84) January 2021 value = -167,217 The last value is cell=(Z84) December 2022 value = -136,485 The Cost values go across…
-
Is it more efficient to divide by 1,000,000 or divide by line item of 1,000,000
Hi I am building an output module and need to divide everything by 1,000,000. Is it more efficient to just put / 1,000,000 or / S01.oneMillion? See the ss for an example of one of my formulas Thanks