-
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.
-
Get previous Item in current list
Hi everyone, in Time period, i can use PREVIOUS() function. In my module, i dont have time period so i created a list which has Week 1 to Week 52. if data from module cash balance is 0, then previous ending balance will become the beginning balance. but it gives me error. here is my module.
-
How to send Delta loads from Hub to spoke with dimensions ?
Iam having few questions in anaplan build .Some one please answer. Q1. There are Business units the team wants to look for different Versions Variance 1. Variance 2018 to 2022 (2023 not to be considered) variance 2. 2019 to 2023(2022 not to be considered) Variance 3 : 2018. Q2. There are 3 years of data in hub. How to send…
-
how to compare week time to month period time
Hi may i know what would be the best way to compare the week (time) to month period? Thank you.
-
How to Push Selective Data from One Module to Another
Hi ALL, I need assistance with setting up an integration between two modules in the Model. I have two input modules, Module1(Dimension UID1) and Module2( Dimension UID2). We have few common columns between two modules. These should be populated. When running the integration, I want to transfer data from Module 1 to Module…
-
Count the total number based on filter KPI
Hi, I have a Count line item of employees that has a formula of 1 in my employees module. I have a Total Count line item on another module to show the Total Count based on Filter that has a formula of: my Filter formula is: How do I show the total count of employee based on the filter? Thanks
-
Show all data if no user filter selected
Hello, I have a user filter selection. It only shows data after filtering. How to see all the data even without filter? Thanks.
-
USER Time Filter Selection
I need to filter Months based on the user selection . If user selects FY 25 corresponding months should be displayed.
-
1.4.3.2 Import Data & Add Formula - adding formula
Hi, I try to add formula to the code line, but I get error that says 'code does not apply to any lists', what is the problem= Kind regards, Katja
-
sort functionality for nested dimensions
In our Anaplan Model, for one of the modules , we moved the dimension from the Context selector to the Rows section. This is because we want the user to select the dimension using the "Field" Card [dropdown] instead of selecting it from the page selector. Based on the user's selection from dropdown, entire page will be…
-
Need help with a time filter
Can someone please help me implement the given scenario. I have implemented it but there are certain loopholes that I am having trouble fixing. Scenario1 : I have a module with version list on rows , 4 line items(1,2,3,4) on columns and Time range FY15 on columns after line items. For LI 1,2,3 I only want to see years and…