-
Filter list using list property
Hi Hoping someone can help me solve this issue I am having. Probably doing something very silly! I want users to filter a list of managers which is a subset of the employee list. I wanted to do this through a list property driven by a line item in the model. I have done this before but I cannot seem to get the dependent…
-
Error while applying user based filters
Hi All, I have 3 modules, let's say A, B and SYS Filter A module has dimensions - Stagging list, custom versions. B module has dimensions - Stagging list, subset custom versions. SYS Filter Module has dimensions - Stagging list, custom versions and Subset Users. while applying same filter from Sys filter module, A Module…
-
Update subsets for the lists with Selective access
Hello, could you please help with following situation. I have the flat list of positions for which Selective access is set (according to the access of the user, so that HRBP of the Facility 1 has access only to applicable positions). All the major calculations are made on this list of positions ir order to save space…
-
Formula for Quantity Multiplied by Price
Hi, I'm playing around with some dataset I've found. The data only has values up to the month of June. Is there a function for getting the unit price based on the quantity that I will input for each month multiplied by the price of each product in every location? So that I could fill all the months with no values. I also…
-
How to SUM the last three months
In the line item "last 3 months sum", I'm trying to sum the last three months. I tried using timesum but wasn't getting the right numbers. Any help appreciated, thanks!
-
Last 52 weeks Calculation
I have a requirement to show the last 52 weeks value. I want to create another line item which has to sum last 52 weeks total hours e.g.: 03/08/2025 should show the last 52 weeks data this should be dynamic and 52 weeks should change based on the week. Thanks in Advance.
-
Resync PROD - DEV Enviroments
Hello, I needed to do a rollback on the PROD model to an ID from the History, so it implied to get the PROD from DEPLOYED to STANDARD mode. I knew before that this will happen, but it was kind of urgent to solve the issue that we had so this was the only way. Now I am asking you, what is the best option to resync the…
-
Getting 0 results from a COLLECT line item
Hello, I have a line item that has a COLLECT() formula. This returns the values just fine. But when I use this line item and Lookup or Select a specific member, it doesn't return any value. Is there a way to do this, or am I doing it incorrectly? LINE ITEM FORMULA APPLIES TO SUMMARY TIME Source line item COLLECT() List 1 &…
-
Mapping of data with combination of properties
Hi All, I'm new to Anaplan and still learning it's way, would appreciate any ideas aligning with best practices. Here's my question: I have a list with combination of properties say products, location, customer, and for each such combination there's a sales person, now I have Sales transaction data with product, location…
-
Is that possible to customize the time scale text?
Users export forecast report every day, they are wondering if the time scale here e.g. "Week 1 FY25" could be "Week 1 FY25 (2024-09-29)" which add a START date of this week, otherwise they have to manually add it in the excel file. Thank you
-
Invalid Formula error?
Hi - I am copying the same formula from another cell, and adjusting the start of the formula to another cell so should be straight forward, but I keep getting 'invalid formula'. Please see screenshot below. Can someone please advise? Thanks
-
Getting rid of the dimensions in a dashboard
Hey little (maybe stupid) question, A couple of months ago, I was able to get rid of the dimensions in a dashboard by clicking twice on the line between the dimensions of the rows and the grid itself. So when I did this, the dimensions disappeared and only the data was visible. Now, is it possible that this functionality…
-
How can I import this data in the correct way?
Hi, I am facing a challenge with uploading a file, can someone help me? This comes from the training level 1, chapter 8 I don't know what I have to fill in at the forth line option? This needs to be the outcome:
-
How do I get the correct mapping?
Hello, I'm facing a mapping issue, wherein I've a module with 3 dimensions & few line items- Lets say Dimension X, Y & UID with a line item formatted as dimension ZZ Then there's a 2nd module with the dimension ZZ , Y & the same line items- There's a mapping between ZZ & X so I can lookup that & pull the values, dimension…
-
How to summarize from daily time setting to monthly?
Hi Everyone! I know this is still pretty basic but I am still learning the basic formulas and functions of Anaplan. In the first picture as shown below is I derived tons per day: Now, I must consolidate the monthly tons in a separate module, however it sums up to 0. Supposedly, there should be a value on Aug 25 and Sep 25.…
-
How to build - KPI function with varying start dates, term lengths, and repeating?
We'd like to do something but I am not sure how to do it or if it is possible. Basically creating a KPI system for employees where managers can create KPIs for employees that are 3/6/9 months in length, start at any given month, and then continually repeat. So if John has a KPI start in March of 2025 that is for 3 months,…
-
Counting Headcounts of Male Fulltime Employees Using IFTHEN Formula
Hello, I am having trouble counting the number of headcounts using the IFTHEN formula in Anaplan. My formula: IF '01_PSFT・Excel data'.Contract = "Fulltime" AND '01_PSFT・Excel data'.Gender = "Male" THEN 1 ELSE 0 What I want to count: people to be categorized as both ・Contract column:Fulltime ・Gender column:Male I created…
-
Column Customization
Hi everyone. how can i create below sample in ux page.
-
Planual and Testing the model
Hi All, Is there any way to test our model whether it is following the best practices . For Eg: I encountered problem like I am writing the same formula in multiple modules and referring them . Is there an sandbox environment where we export our Model data into it and then it will give results like "you are using this…
-
Transfer Value from Time Period to List
Hi everyone. i have time period (weekly). since weekly is the same as gregorian calendar. so i created a list which week 1 to 52. now i already have data from a module which has a time period. my mapping: sample is week 8 from Cash Balance Beginning - Copy, it did not reflect in Sys Time Mapping.