-
Putting values in territory field from multiple quota assignment rows of an employee into one field
Hi Experts, Appreciate your brainpower on below challenge. Using below test employee as an example, we would like to have a field show “PKI, BCT” in the same row same cell, similar to concatenate or textjoin in excel. Expected result like below (using excel as demostration) Thanks a lot!
-
Retrieving last non zero value for daily exchange rates
Hi, I have a daily exchange rate module which store the daily rates for multiple currencies. I wanted to get the last non-zero value for each date for example we have daily exchange rates for 1 Jan 2021 but none for 2nd and 3rd of Jan 2021, so the daily exchange rates for 3 Jan 2021 should display the rates of 1 Jan 2021…
-
how it work for sales manager
how our platform work for a sales manager who is responsble for profit and loss account of food products marketing company
-
How to Auto-hide line items
I have a table which include value from Q1 FY21 to Q4 FY23 as line items, and want to hide which the value is 0. But when I use filter on line item will hide other line items like KPI Name (it is TXT format). How can I hide these line items which value is 0 and does impact other no number format line item? Thanks!
-
Display months as M1, M2 instead of Jan, Feb
Hi! My company uses a 4-4-5 work week calendar. Currently, the system shows the months has Jan, Feb…Dec. but I would like it to display as M1, M2….M12. The reason being is that our M1'23 has a date range of 12/31/22 - 1/27/23, therefore, saying Jan is misleading. Thanks for the help!
-
Can you link to a specific record on a new UX page
I have a list of projects and i have a line item that is a link to the project page, but would like to go to the specific project they are clicking on. The html for the page is the same no matter what the item, but can you add a tag to the html at all, like you can in other apps?
-
DCA by User´s role
Need to generate a DCA module that depends on users role. I have seen that there is no capability to extract the users role, any suggestions? br
-
Add List Search Option while create module and Import from Existing Model
Hi Team, If we provide a search option to select a list when creating a new module, it helps model builders select the required list. Similarly, if we provide a search option to select the source for any import from existing model views or lists, it also helps model builders.
-
Best method for Scenario Planning?
Hi All, I am currently in the process of investigating the best methodologies for building in scenario planning into one of my models. After some internal conversations and a little community hunting, I thought it would be best to write a new post. For context the model i am building scenarios into will require several…
-
Filtering based on User selection
Hi I have 4 modules, with hierarchy regions set up. All 4 modules with dimensions are described in ss. I want to apply a filter on last module for only the countries selected for particular user but I am unable to do it.
-
Planual
I am proud to announce the launch of the Planual, the first-ever collection of global best practices for Anaplan model building. Created by Anaplan experts, customers, and partners, the Planual collects a wide-ranging set of guidelines, techniques, tips, and tricks organised to help model builders avoid common problems and…
-
New to Forum
Hey everyone! My name is Chad Pyke. I just started my Anaplan journey and am excited to learn from each of you! I'm hoping to transition into a career in Anaplan/EPM by EOY and would love any advice or counsel you have on the customer vs partner track. Thanks!
-
Schedule of CloudWorks only working days
Hi, I want to run process on 1st Working days in CloudWorks. If I want to do this, I should use CloudWorks API? Month First Working day 4 3 5 1 6 1
-
from where to get cotton candy data
Hey Team, From where to get cotton candy data for model building. I recently started learning can anyone tell me.
-
3.3.5.6 Update Inventory Ordering to Calculate Shipping Costs
Hi all, I'm having difficulties with the Shipping Cost line item. I am getting an error on the formula below…Can someone kindly point me in the right direction Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: Shipping Methods]
-
Fix Window like Excel in UX
Hi, I want to use fix window function like Excel in UX. I want filter card to always located on top of the page. Is there any way to do this?
-
Anaplan is not allow my export showing message Excel workbooks cannot support more than 65536 rows?
-
2.4.8 Demand Review UX Page
Hello, On my pages for DEM03 Demand Forecast I want everything on one page from top to bottom. It will not let me move the menu's on the right side into main screen. Any idea how to adjust this ? Dragging into boxes highlighted does not change anything.
-
How to fix summary settings for hidden cells
We have read access on months we don't want people to see, however the summary for the whole year will still take the sum of the hidden cells. We don't want to remove the yearly summary or zero out the amounts until they are ready to be seen as that would cause issues on our end. is there a way to summarize only cells that…
-
Activity: Import Data into FP&A Model LVL2 Conclusion
I am trying to import the information from the INV05 Module but get items failing. This is my save view, how do i make for the G3 location list only show me the lowest level of information without the country and region? Thanks in advance
-
Production Capacity Module_Factory 2
Hi, Does anyone know how to build a calculation module in Anaplan that calculates production capacity using the formula bellow, and includes the option to check whether the factory is working on weekends: This is the formula I am using: Production capacity = number of machines*number of working hours*number of working…
-
How to create a new hierarchy of an existing account code and then show the result in new structure?
My company has change the groupping of the existing account code. I do have Account L2 list and Parent Account L1 list. I need to create a new Account L1 list and a new Account L2 (Copy from existing ones). I try to copy P&L module and apply the new account L2 list but it does not work. Basically, I need to keep old module…
-
Average value
Hi I want to be able to calculate average values of 3 years prior and show them as the value for this year. So, if I am forecasting for May 2023, it would be the average of values of May 2020, May 2021 and May 2022. Please suggest how to achieve this?
-
Average value
Hi I want to be able to calculate the average values of 3 years prior and show them as a value for this year So, if I am forecasting for May 2023, the value will be the average of values for May2020, may 2021 and may 2022.
-
L2 Sprint 2 2.3.9.1 Import data DATA02 shipping metrics
Import Ignored most likely due to different dimensions. However I don't see anything in original excercise saying dimension should be weekly in the data hub module, please assist ? DATA HUB it is Model calendar year >> Time scale Year In Supply chain this is based on time range. >> Time scale Week Supply Chain Module
-
How to know a parent is selected
Greetings, We have a model where a Employee have territories assigned, each territory have accounts assigned. At the moment if we edit the end date of a territory the end date of the accounts stay the same. So i want to make a formula where if we mark the territory for edition , a boolean on the accounts gets active as…
-
Uses for TEXTLIST
Hi All, I am unsure where I might use TEXTLIST function. There has never been a need for me to use this but I would like to understand where, when and how this might be useful. Your insights are much appreciated!!
-
Waking up the model with Cloudworks
Hi everyone, As you know, initializing the model (moving it from disk to memory) can take a while, especially for the larges ones. This can be quite painful for the first users of the day, or for the first one to connect after lunchbreak. I don't find precise or recent informations about it, so here are my two questions:…
-
"Sorting an axis with nested dimensions is not supported."
Hi all, I am having an issue trying to sort the column "total orders" of the table below: On the left, first column, are the Units, in the second column the suppliers belonging to that particular unit. The column named "Order Amount (eur)" shows the orders of a certain supplier who has dealt with the unit, while the last…
-
2.3.9.2 Update and Run Process 9. Import Data from Hub Item 9.1
I am trying to import into the supply chain module for 9.1 for DATA03 Historic volumes. It seems my mapping is not correct but not sure which step it occured. Any idea on how to fix this ? Attachment has full details.