-
Importing data from another Anaplan model using a filter in the destination model
I have a client who would like to use an existing view in the data hub as an import, but doesn't want to bring all of the data over from that view. Is there a way they can have a filter in their model so that when the data is imported from the data hub, they don't have to do any additional processing to remove the extra…
-
Cross Referencing Between Lists - Dimension of mapping used for aggregation doesn't match any dimens
Hi All, I'm taking our demand planners monthly forecast and converting it into daily then rolling it up into weekly buckets. I've successfully gotten us down to daily, using a fake timescale, added the week commencing date and I'm trying to do a SUM function with each day that matches the weekly period being added up. The…
-
Override function to SUM function
Problem Statement: We develop a table setting out the results of transactions per code type across multiple categories (AP, AR, GL. etc). The results are calculated from detailed transactions . The customer process dictates that the amounts determined should allow for overrides to assign the amounts (all or a portion) to…
-
Property in List using a formula
I have a unique key list which is a standard naming convention of 12345_123456_123456. I would like to use a formula to identify the last 6 digits that are not 000000 or 0000002 and create a list subset of those. Can you help me figure out the formula for that? Thanks!!
-
auto populate other fields
First and Last Name should be a list Email - must be users email ID is a list if the User provide value in one of the above and others fields should be auto populated.
-
Level 1 Model Building
Hi, In Level 1 Model Building, we are asked to create an Employee System Module, with Start and Leave Date with Date format But in the Excel provided, the format is And During import, it says Invalid Date. Could you please help to know how to fix this. Should I change the format to date in excel and then import or import…
-
Re: How to Group Total sold from 4-4-5 to calendar month if data is weekly commencing monday?
@JaredDolich Your solution worked great and it's exactly what I'm looking for. I would like to ask a follow up question on the topic in the link below: https://community.anaplan.com/t5/Anaplan-Platform-Discussions/How-to-Group-Total-sold-from-4-4-5-to-calendar-month-if-data-is/m-p/59830# One question I have is that when I…
-
circular reference error with no time dimension used.
Hi All, I have a module without time dimension,I am facing circular reference error here: Line items used are: Total = Sum (Lineitem1 + Lineitem2 +Lineitem3) I need previous cell value of Lineitem Total for LineItem1 ie, Lineitem1 = previous(Total) As I am not using time dimension, I cant use PREVIOUS function here.…
-
How to count booleans?
Hi - I am trying to create a graph where it displays the number of items selected by the user. These items are marked through booleans. Is there a way where I can count how many items are selected per category using the booleans? Thanks!
-
How to freeze a verson from change in master data
Hello, I would like to have a "budget version" free from any change; formulas, list, metadata. Is it possible to do it with Anaplan? Is there a way within Anaplan to freeze a version i.e stop it from being rules calculated, whilst retaining the data? And can you help me with this? Best regards, Gaëtan
-
Sum of amount based on numbered list.
I have a numbered list, which has the same names (display names). These same name line items then have different child. The values of the same name list items needs to be added up to only one list item which has the latest PO date in the same list. For Example- This is the source module that has the same parent names with…
-
Alternative to LOOKUP with non-composite hierarchies
I have a list in which there are parent and child relationships defined. Ideally, these should have been created within a composite hierarchy but at this stage I am not considering redesigning the lists. Is there a function whereby I can reference one of these parent items? Example - Shoreditch, Westminster, Clapham are…
-
How to get the last row number
Hi,everyone. How do I get the last row number of a line item with characters entered? I would like to get row number "5" from this module. Could you tell me how to get the number? Best regards.
-
Line Items that Do Not Need Time Dimension Appear Blank in Grid View for Some Modules
Hello, I would like to ask and gather some feedback on the situation I am having regarding the above subject line. I find it strange that a module which has a line item that does not need a time dimension (it's set to Not Applicable) shows the information and the other module does not. For example, in module A, I have a…
-
Formula issue - Add value from previous months
Hi Guys, I have been working on this formula for quite a while now, I hope you can give me an idea on how to do this. I will explain it as much as I can since I cannot provide a screenshot of the actual report from the client. I have 2 tables with Line Item and Time Dimension. "Value 1" row has the value, "Identifier" row…
-
Locking in Submission Date
I have logic built out where an employee will submit a request to be approved by management. This is not very dynamic, the employee simply enters text in line items and then those line items will adjust to "read only" once manager has selected approve/reject on their end. Is there a way I can add a submitted date line item…
-
Anaplan Models With Machine Learning Model Feeds
Hi Ana planners I was curious to know if anyone has any exposure on building Anaplan models integrated with ML models feeds deployed in other cloud environments such as google cloud services. Anaplan conducted some POC with google in exploring the possibilities of leveraging ML capabilities on Anaplan. Does anyone know on…
-
Anaplan Calculation Order of Operations
I am trying to write a simple formula and Anaplan keeps removing the parentheses which causing an issue with the order of operations needed. What am I missing here? Do I have to break out both parts into separate line items or is there a syntax issue? Desired: ('Total Units (Final)' / Total Units) * ('Qty1' / Qty Final)…
-
Curious to know the Best Practices for Model Cleanup in Anaplan?
Greetings All, Please check out my new article on Model cleanup activities. If you have any questions, please let me know. Link here Thanks and Regards, Kavin.
-
How to make two versions formula driven and one version editable in the same module
Hello, i'm using three versions in my module, here Actual, Forecast, Budget. i have the actual and budget data available and they can be formula driven. Forecast data should be a manual entry data. Can any one help me solve how i can pull in the actual and budget data formula driven while i leave the forecast data…
-
Level 2 Training Sprint2 P3 SKU - No line items
I am busy with the level 2 training and hit a small hick-up I build a few modules referring to the P3 SKU list and worked fine until yesterday. This morning i get this message: But if i look at the list, i can see the list items There are no sub sets Where do you suggest that i have to look to resolve this challenge?
-
Changing the appearance of child items on a List
Hi Im trying to see if there is a way I can change the format of Child items in a list i.e. to make certain child items appear as Bold or italic. This is to be used in a Reporting module , I cant use line items as I need to perform certain calculations on a List that represents the layout of a management PnL. I don't want…
-
Formula problem - adding values in the same line item
Hi Guys, I just want to ask help on the formula. I was able to create a formula and got the values but the succeeding time does not show no values. This is what it looks like in excel I also included the formula on the sheet for col K, L and M. Row 7 will just add values. I got the first two values correctly. See below Row…
-
How to FINDITEM without CODE
Hi everyone, I would like to get the value from the list using FINDITEM, using a Property other than CODE. I don't have to use FINDITEM. I woud like to know if there is an alternative. sample... I would like to use "Any Code". Could you please give me a solution? Best regards.
-
Change version switchover
Hi All, I am having problems adjusting the version switchover manually. But I have heard that it is possible to make this adjustment with an import action. But the problem is I don't know how to do this! Can someone help me and tell me how I should build this? Thank you!
-
Circular References
Hi, I am having problems with what I think should be a fairly simple calculation but I'm not sure what I'm doing wrong. I have a debt value. Interest is calculated on that debt value. Every 6 months, the cumulative interest is added to the debt value and the interest for the next 6 months is calculated on the new debt…
-
Circular Reference in module with no time dimension
Hi All, I have module which has no time dimension and with 3 line item Bond, Sale, Total Calculations are as below Bond = total (When i right this formula its throws circular reference error) Total = Bond + Sale I have getting circular reference error, Please let me know if any solution to resolve it. Thanks & Regards,…
-
What does the little drop down menu icon in Actions do ?
Screen shot Currently it says no actions available atleast for me . Wondering if anyone has any 'Action items' showing up there ?
-
Error message: Cannot breakback
Hi all, I have a dashboard for forecasting and I want to allow users to copy from one quarter to another quarter, using breakback (at a quarter level instead of monthly level). For some reason, whenever I try to copy values from one quarter and try to paste them into another quarter, I am getting this message: Cannot…
-
Pouplating year value without Time dimension
Hi All, Can you please help me in populating the attached years by formula , where I am not using Timescale in the module and my Mapping Year (line item) format is Year. CHRT** and YR** are my two dimensions used here.