-
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.
-
Ability to create a budget version, copied from another version, with values that don't change
I want a version that contains values from another version, but doesn't rely on lists/formulas/etc. Changes to the model should not affect this version copy. Description of the enhancement required: I want to be able to take a copy of a version which is just a copy of the numbers, so once you agree the budget it is copied…
-
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…
-
Numbered lists to add display name by default
I think it would save a lot of time during initial model setup if the following actions happened when a model builder checks Numbered List within the general lists panel. * New property within checked list created called Display Name. * Display Name property format set to text. * (Potential) Set Display Name property…
-
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!
-
Import error formula
Hi Members, I am adding formulas to the properties, I am thrown this error. The actual output (mentioned as output in pic) is shown. Please assist me with the correction, that needs to be done. Regards, Sravan.
-
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…
-
Import in a numbered list
I am facing this error while importing the values in the numbered list. Can someone please highlight what this error means.
-
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 ?
-
Import Action Error
Hi Anaplanners, Need help with the following error: Can you please let me know how to resolve this..? (See the pictures) Thanks in advance, Ankur Sonthalia.
-
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.
-
Improve FINDITEM() when used with Time
Similar to improving imports with time periods (Idea Link), it would be great if the FINDITEM() formula was tweaked when working with Time, to make the formula return time periods for strings like Jan-20. Reason for asking (lifted from my previous post in the Idea Link): The standard excel format for Month-Year is MMM-YY.…
-
Add conditional formatting icon sets
The 'Icon Sets' feature in excel conditional formatting is a tool that I really like. It looks very clean, and can convey a broad amount of information quickly. It would be great if Anaplan could incorporate some of these into the conditional formatting menu, using a similar logic to excel. For those unfamiliar with icon…
-
Add shape to New UX cards
It would be great if page builders could change the shape of certain cards within the new UX. For instance, the ability to choose between rounded square, circle, or rectangles for KPI cards This would give page builders more options in: * aligning page themes to corporate branding * displaying visual data in creative ways
-
New Style for Line Items
We have had a client request for a line item style with one line above and two lines below a specific line item. This style is very common in financial statements and SEC filings and would be beneficial if it could be reflected in Anaplan. I have also seen requests for the style to be reflected in the dropdown in blueprint…
-
Word wrap on rows
It would be great if model builders could enable word wrap on rows as well as columns. It would be even better if Anaplan could dynamically check each row, see which rows required wrapping, and only increase the row heights of rows where wrapping is required.
-
Adjust row heights for list or line items
It would be great if model builders could define row heights for list items or line items when pivoted to rows. This could even be controlled within another module. For instance, a model has one list Countries. One module would control the row heights of Countries, contained within a line item Row Height. Another module,…
-
How to Lookup in different dimensions
Hi everyone, I have two module. I want to post values from a module that does not have a date dimension to a module that has a date dimension. Also, there are two target Line Items. The mounting image is as follows. I would appreciate your advice. Best regards.
-
Filters
Hi, I’ve built a filter (boolean) consisting of 3 levels with dependencies. If I choose an item in level 1, I will only be able to select items in level 2 that are dependent on the selection done in level 1. Same relationship between 2 and 3 as well. This works well downwards but not upwards. When I delete (leave it blank)…