-
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
-
Mgmt Reporting: Table Card Variances
Hello, I'm new to the "management reporting" feature and am hoping someone can please help me with Table Card Variances. Is it possible to calculate the change in basis points between two percentages? Thank you, Amy
-
Concatenate multiple items
I'm slightly confused on the best approach to concatenate multiple items into a single text line item (where neither is a code or part of a list) For example lets say I have a module with the following line items T1, T2, T3, T4, T5, T6 and T7 and Concat line item is C1 Currently C1 shows: T1 & "_" & T2 & "_" & T3 & "_" &…
-
How to pull previous year end balances into a monthly calc
Hi So I am having a bit of an issue I need to do a calculation monthly, but I need to refer back to the previous year end balances as my start point for all months. I tried doing it with offset, why I take a starting balance for that month, and then offset everything back to December to lookup the amount needed in my calc,…
-
Will change in code disturbs the data it holds?
Hi, I have a numbered list and a hierarchical list that holds important data. Now I have a requirement to update a few existing codes of the lists. I tested using a dummy list and the data was not changing. Want to double-check with the community if I change the codes of the lists mentioned above lists hope It will not…
-
I want Booleans as true as per below requirement
-
Source Label change with change in model in Imports.
Hi, I have a model - Model 1. I took a copy of the Model 1 and named it Model 2. Now in the Import section of Model 2, the source label has still the name Model 1 in it. So, wanted to know when we run the action will it be from the same model Model 2 or it will be from Model 1 from where I copied it. Thanks.
-
create a home page in Anaplan with navigation buttons
Hi all !! Is it possible to create a home page in Anaplan with navigation buttons? If it is, could you please provide instructions on how to accomplish this? Thank you.