-
Cannot Lookup nor Firstnonblank, how can I solve this?
Hi All, I have been trying to come up with a solution to this problem; I need to let the "belong to fab category?" boolean be checked whenever a cost element list item belong to that particular fab category (e.g. "direct labor") Now, the user has been already giving me this information in another module: However, the list…
-
Tracking import date
Hello, I'm having a little difficulty with something in Anaplan. I want to set up a system (module) where every time the end user try to import a new file in a page, we can note down the date it happened. We have different files, and I'd like to keep track of the last date data was brought in for each file separately. i…
-
Add KPIs as line items and steps to define its calculations. Can an admin user do it ?
There is a requirement where I need to give user/admin a feasibility to Add KPIs, define calculation steps. How can it be done ? Any suggestions? As per my understanding, if KPIs are my list items, then we cannot retain the calculations. KPIs need to be line items.
-
Import Error Issue
Hi Anaplaners, I'm importing a list hierarchy with 3 levels. I have added a prefix "DR1 -" for level 1 code and "DR2 -" for level 2 code & "DR3 -" for level 3 code to the hierarchy items to make them unique for successful import. But yet I'm getting an error "Invalid Parent" Below is the screen shot of the highlighted…
-
Running week of sales anaplan
Hi Team, I am trying to get Running week of sales in Anaplan. Below is the scenario. I have 1500 quantity in current week .. i have a forecast of 500, 500, 1000 for next 3 weeks. want to see value of 2.5wks in running week of sales i.e.based on forecasted numbers . Can any one help on it
-
Anaplan Bulk API Exports (Line Splitting on last row of chunk)
Exporting a file that ends up having over 100 chunks. The first and last rows of the files are split across different chunks. Is there a a way to prevent this?
-
TIMESUM from a Module with time dimension to a Module with a fakeweek dimension.
Good afternoon, I am trying to map the data in day format to a fake week dimension using a timesum. I have a start and end period in DATE format but the formula only gives me a result when this two are the same. This is the formula: This is the source module: With the data imported to day. And this is where I map each week…
-
Finding duplicate combination/inputs in different dimension
I have module dimensioned by TRID(1-100), Business Type(Type 1, Type2, etc.) and Region(EMEA,APAC,NA,LATAM). This module is used to define rules for each business type and Region. For example: So, these are the inputs/rules for each region . In this example For EMEA we have 3 rules Rule 1. Segment = A Partner = C Rule 2.…
-
using the cumulate function
Hi all, I am trying to use the CUMULATE function to cumulate actuals (number formatted line item) over a subset of periods 'SS Periods Current year' (a subset of custom list, not Anaplan time). I first thought that I could not cumulate because I was using a subset, but even replacing the subset with the full list did not…
-
Transfoming Numbers
Hello, I am trying to get the figures from Eur in KEur. The figures in Eur they are in a Module and if I just apply the classic formula, I will increase the size of my Module as I need them both : in Keur and in Eur (I don't want that).The figures in KEur I need to show them in the UX, so I am searching for a way to show…
-
Revenue Distribution Help
Hello all , I am trying to find the best way to distribute forecasted revenue across multiple periods based on a distribution chart (so to say). I will attach screen shots to better explain. Each month has a forecasted value: Each month's forecasted revenue will be allocated based on this chart: Period 1 would correspond…
-
Including Text within a Number Formatted Line Item?
Our client requests to see "no MTA" when MTA= 0 and Warehouse <> 0. However, instead of 'no MTA', I'm getting 'NaN'. Is it possible to include text within a number formatted line item? Formula - Final MTA = IF MTA = 0 AND Warehouse <> 0 THEN VALUE("No MTA") ELSE MTA
-
Need Help with Exporting parent list item in different tabs
Hello Everyone, I Would like to know is there any way to get an export in such a way. Like, let's say we had a module with hierarchy list. I want the parent items in Different tabs of an export and all the child items associated with that parent should reside in respective parent item tab. For Eg, we had R1 Request ID, R2…
-
Usage of First Occurrence formula with conditionals
Hello, I'm using the ISFIRSTOCCURRENCE formula to assist in creating hierarchies so the processes don't return a bunch of errors when generating the hierarchy, but now I'm facing a little issue, I want the first occurrence formula to return true only if other columns match some condition, but I can't find the correct…
-
Data Display in a UX page
Hello everyone, I have a table displayed on a UX page (a worksheet) containing multiple line items in the columns and a list of months also as a column (where each month is a child of a quarter, which is a child of a year). I need to address two challenges: Filtering Data by Months or Quarters: I aim to enable users to…
-
How to Achieve in pre-built Anaplan Eco-System , Hierarchy into to flat list & Replacement
Hi All, Currently the Anaplan eco-systems has multiple workspaces and multiple models[8 workspaces ~55 GB], now there is a proposed hierarchy change(as some models are quite complex and have Dependency on that flat list to create further Folded Lists for Reporting) 1. The List to be eliminated is a Flat List 2.Against that…
-
How to delete "filter" drop down selections - case: driver -> filter/driver -> filter
I have three drop downs: Division (driver), Area (filter/driver), Type (filter). At first Division is supposed to be selected. Area drop down list members are defined according to Division selection. And Type drop down list members are filtered according to Area selection. Now: 1) If I change Division → Area and Type drop…
-
Custom Date Format while exporting
Anaplanners Currently I have a grid at a day wise granularity. While exporting the grid the day is shown as follows: 1) As row header [here time is pivoted at a rows] - format comes as '1-Apr-2024' 2) When i bring it as a line item [with formula- ITEM(Time)] format comes as '4/1/2024' I would like to get a custom format of…
-
Months as Line Items
https://us.v-cdn.net/6037036/uploads/KEA3C7HMON5U/requirements.xlsx Background I need to design a UX view for our finance team that shows the entire year Jan-Dec, with past months showing actuals and future months showing forecast. I already have sales actuals and sales forecasts sitting in modules that I can reference,…
-
Model is Busy (Running exports while people are trying to use the model)
Hello, wondering if it's possible to somehow use a model when someone else is running a heavy export action. We currently have exports scheduled at night but sometimes we need to run them during the day. However, when this happens anyone using that said model is locked out basically because the model is busy. The exports…