-
how can we decide the order of data while displaying them in grid in a reporting slide
so if I want to compare line item values for A,B,C,D,E but i select them in order of BCDAE for displaying in grid in the management reporting slide feature of Anaplan. How can that be worked out?
-
Previous list item in formula
Hello, Is there a way to assign a value depending on the previous list item? In my case, I need to assign the value 1 to the week 5, value 2 to the week 6 and so on until week 9. The values always go from 1 to 5, however the week number might change (for instance, choosing RFC24/01, value 1 is to be assigned to week1 ecc)…
-
3.3.5.2 Inventory Ordering Module Formulas
Why do I not see the values for 'beginning inventory' in my model?
-
Time Dimension & Value not adding correct
I have a model which has the time dimension (in days) and line items which are date formatted. I'm trying to create a chart which correctly replicated the progress of time change but for some reason any value is not mapping to the x axis of the chart. I have attached a picture for better understanding. In the picture you…
-
Revision tags with multiple builders
My client is asking what is the best way to allow multiple model builders in Anaplan independently? In the current system there is no way to isolate what changes should be moved to other environments, i.e., revision tags are cumulative. How do you all handle this?
-
Summing a line item with a formula summary method
Hi I have a module that is calculating correctly for each line item when I apply the Formula summary method as its based on the dimensions listed in the context selectors. I need to return the sum of this line item (highlighted in yellow) in another module but it obviously returns zero. I am sure I am missing something…
-
Formula Summary for reporting
Have to run a variance reporting for 3 Line items. In the source, the line items have dimensions and Time(Quarter). The variance Reporting module is run by the same dimensions, the source line items act as a dimension(by line-item subset) and looksup the Year selection by the user. The challenge is that one line item has…
-
Is it possible to colour input line items for ease of inputting. For eg as added in the screenshot.
Is it possible to colour input line items for ease of inputting. Also this colour should be present even before any data is inputted.
-
Need to know if we can take out some GB from 1 workspace and put that space into different workspace
Hi, I have a question where I want to split out like 30 GB from one of my workspace and put that 30 GB into different workspace. Current Situation Workspace 1= 130 GB Workspace 2= 300 GB Required Situation Workspace 1 = 160 GB Workspace 2= 270 GB If its possible how can we do this. Thanks
-
I NEED HELP ASAP
Hello, I need your help please!! I wanna import this file CSV in a list on Anaplan without edit the file. should i import the file in a module and create a code for each line then import the view in the list ? and how to do it ? thank you RGDS
-
Calculations with list items
Dear all, I created a line item "Figure" and a list "Divisor". The list just contains two values: 12 and 24. I further created a line item "Result" which should display the result of Figure divided by Divisor. So my module contains three line items: Figure: Number Divisor: List Result: Number Unfortunately Result = Figure…
-
Converting a Classic model to Polaris
Hi, Is it possible to simply port an existing model built using the classic calculation engine into Polaris? Thanks,
-
Adding list items, but only display the result when a list item is selected
Hi all, I'm experiencing an issue in my module where when selecting a certain list item ("online" - in the screenshot), the numbers aren't displaying as they should, and I'm getting 0 in every line item. I think this is a build issue, however I want to try a hotfix by adding two different list items that I know total to…
-
Level 2 Sprint 3.3.5.5 Final Shipping Method
I think the whole system of candy corn crumbles on the change of "shipping method", because the reorder flag is based on the standard shipping method. So when the system says I have to reorder but I choose to override the shipping method with another shipping method that is slower than the standard, i will receive my order…
-
Why do filters break when pivoting a view?
Hi, Why does pivoting a view cause filters to break? This has been a major pain point for our users- is it possible there is a good work around? Thank you.
-
Formula to allow duplicate
Hello, I am trying to make a formula in order to be able to create duplicate codes. At the moment my formula goes like this: IF Boolean THEN Concatenated Code ELSE Blank And I want for my formula to do this : IF my boolean is checked, then my formula should return the Concateneated Code but i want to allow a duplicate not…
-
Workflow: No assignees
Hi, Currently building a workflow functionality. I have a Group Task that relates to creating a budget transfer request. This task is dependant on the user input, if a request amount is higher than current budget, we would notify the budget holder. My question is: Is it possible to skip the task in the workflow if there…
-
Is there any way to export the line items wise view, by using export action(date format line item)
Line-item kept in page selector as Date format
-
Assign values to duplicate items
Hi I have below module that is update every few days UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan two records were updated when the next time(eff from) the job runs like below UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan 5 A1 25-Jan 6 B1 25-Jan I want to…
-
Replenishment modeling with circular reference
Dear Anaplan Community, I am facing a circular reference issue modeling replenishment calculation. For this specific client, their trigger condition to place an order is to evaluate below condition: If I do not place an order today, will my projected end on hand (EOH) on this Item's ETA date fall below this item's safety…