-
Spreading amounts
Hi Anaplan Experts, I'm not using native time and wanna use the SPREAD function. However, This function needs a time scale. Some functions can't run in custom time, such as OFFSET, LEAD, PREVIOUS, ETC. What are your thoughts on calculating asset depreciation with the LOOKUP function?. Kind Regards,
-
Formula error
My formula is not working. Here is what I have: IF 'Sales Trend V4'.'2019A' = Gross Sales.'2019A' THEN 'Sales Trend V4'.'2019A'[SELECT: GL Name Sales.Sales] / 'Sales Trend V4'.'2019A'[SELECT: GL Name Sales.Cases] ELSE IF 'Sales Trend V4'.'2020A' = Gross Sales.'2020A' THEN 'Sales Trend V4'.'2020A'[SELECT: GL Name…
-
Looking up a module populated with same numbers
Hi I'm trying to lookup data in the format below. My LOOKUP formula is working but the issue is its only picking up the first record (Product P1). P2 and P3 are ignored as the numbers are the same. While this is counterintuitive, I need to work with data like this as the duplications could be either genuine or in error but…
-
Filter List Hierarchy of non-composite list in the UX
Hello! I have found very gentle and beautiful solutions for filtering lists if they are composite ones, but i am struggling to build a filter for a-non composite list which has 5 levels of detalization. Hierarchy looks like this: And in Anaplan it looks like this (client does not want a composite list, he wants it in this…
-
Medical Expenses Level 1
Can some tell me why I get 0 for the medical expenses? It doesn't give me an error message but just shows zero. I posted screenshots I used this formula: IF Employed? THEN 'EMP03 Employee Drivers By Role'.Medical Benefits[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
-
Renaming the line item - Best Practices
Hello all, I need to rename a line item in a large model, I am wondering what are the best practices to do this? What should I consider before renaming to avoid destroying the model? Thank you in advance for your help!
-
Enable user to choose picture size
From 1 line to several, so that a same dashboard can have several use cases (compact table to work on, then small/medium/large images to have a recap to browse).
-
hierarchy list and child list
hi! When I check list items in the parent hierarchy, I want to create a mechanism to check all items in the child hierarchy. What i should do? Please help me.
-
L2MB-S3 AD02 Override Amount formula
Hi, I am trying to enter the formula for a question in L2 S3 exam. It says my answer is incorrect but in the model it is giving me the desired result. I want to confirm that my understanding about AD02 is correct. Override Amount - Write? is a Boolean formatted line item. Formula for this line item is based on INV01…
-
AD02 Inventory Ordering Overrides
for the override amount write? line item is my formulae correct 'INV01 Inventory Ordering'.Override Suggested Order Amount? AND 'Submit Purchase Order - Write?'
-
Capturing User roles
I was trying to capture roles of the current user in a line item, I see that we cannot refer the model role from user settings directly The other way i can think is to take export in a csv and upload it back to required module but is there any other way which will not need export? My ultimate goal is I wanted to mask data…
-
Documentation: It Starts With the 'Why'
Documentation is one word that gives most model builders a cold shiver. It’s associated with binders full of information lost in archives or the output of rushed efforts to complete an implementation. As an Anaplan partner, we come across a bandwidth of different approaches to Anaplan model documentation. Let's discuss our…
-
Blank Cell with History
Hi Team, I have a situation where some cells have had data entered to them & this is proved by the cell history but the cell is BLANK. I am struggling to understand why the cell history is not reconciling to the data in the cell. Please see the attached screenshots for an example but effectively I was expecting the value…
-
SUMIF The same parent
Hello, I have a situation, I have a list named "BOM Lvl 1", with the parent "plant sku", and these parent have a "total price". Then, I have another list "SKU Plant Price" where the "Plant SKU" is the same in two lists , and i need to accumulate the total price in these new list: Thanks, have a good day!
-
Allowing Time Sum function to accept 1st argument a function
I would like to ask if you may give timesum function ability to accept other function within timesum parentheses [ex: Timesum(previous(revenue),start period, end period)]. The main reason I asked this, I would like to calculate the average 3 month based on previous figure. [Excel example] In meantime, I would also like to…
-
Line Item Subsets - Use Case
Hi All, When I first came upon the topic of LIS, even though I understood the how of its functionality, the why was still not clear. Created some notes, sharing the notes only here. Additionally have use case examples which I'm not posting yet. But let me know if anyone wants 😊. Please bear in mind I am a fairly new…
-
Error while importing data country.csv
Hi Can any one help me on the below error.
-
Remove Selective Access for a module
We encountered a situation where we had selective Access enabled for Regions. A user had following access: Region 1 - Write Region 2 - Write Region 3 - Read Region 4- Read Region 5 - Write. We had to create a boolean filter on Regions. Since, the user has only read access to Region 3 and 4, he could not set the filter for…
-
Selective Summaries: Set Summary individually for each dimension
Sometimes, it's the case that we do not need summaries for all dimensions that are applied to a module - I might need calculations to happen for all intersections applicable for the dimensions applied but need roll up only for one of the dimensions which is currently achieved by creating a separate module at higher level…
-
line item: First week of timescale?
how do I build the formula in 'Sys01 time settings by week' for this line item
-
Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas
Hi All, After working on the formulae in this section , the expected result is not as shown is section 3.3.5.3. Please find attached the screenshots of the "my output", "expected output" and the "Sys01 time setting". Request you to guide me where am I committing the mistake so that I can proceed. Thank you, Har**bleep**ha.
-
9.2.6 Activity: Add Formulas to Margin Calculation Module
Hello! I am working on 9.2.6. I have updated and checked all formulas but Revenue, COS, Margin and Margin % do not match with what solution is shown in exercise. Can anyone please help?
-
Level 1 Exam Activity 4 & 5
Hi all, I've been stuck on both these questions for the past 3 hours and now I'm on question 6 and it seems to build on these two previous questions. I've searched previous posts but and I've followed those steps but the numbers are still incorrect. I'm not too sure what to try any more. I have made the SYS008 module to…
-
Unique ID longer than 60 chars
Hi, As per Anaplan's best practice in loading data, we are trying to create unique ID, however, since the original codes are very long, the unique IDs we are trying to create by concatenating the codes of the different dimensions are longer than 60 characters long. For example, we have Cost Center, Measure, FinGeo etc, and…
-
L2S3 Sys00 Time settings by month module Planning Period Filter
To add line item: Planning Period Filter? Saved View Name: Planning Period Filter for UX * Show only the Planning Period Filter line item * Filter to show months only I added this as a line item planning period filter as Boolean and entered true and then deleted it also added a filtered function filter by the line item…
-
To dimentionalise or not
Hi All, When I was doing Level 1 model building training, had many doubts coming up in mind regarding modules and dimensions, started jotting notes to clear the fog in my head 🙂 thought to share it, perhaps it can help other new learners! Or something that I haven't understood right and needs to correct.
-
Query sales order data into sku properties
I am currently working with a dataset that has all sales order information and have the goal of creating a boolean formula to mark true if a sale on a product has occurred in the last two years. The data module and sku modules are related based on a column with item ID numbers, but I am having trouble pulling the sales…
-
anaplan limits
Hi Can you advise of a resource indicating limits within Anaplan. e.g. Max number of dimensions, line items you can add to a module; Max size of txt,csv file for data imports etc Is there a help file outling all limits. thank you ravinder
-
Import a csv file to a module where "Months" are line items
Hi, Anaplaners I am struggling with import data where one of its columns represents time "YYYYMM" to a module where Time dimension is "Year" and "Month"s are a line items. Would you take a look at the attached to see what I would like to achieve ? Such an import ever possible ? Thanks in advance.
-
Enable cards from multiple models within the new UX app
Enable cards from multiple models within the new UX app. Currently you can add multiple models to a page, but when you add cards sourced from different models you have to toggle to that model at the selector. After creating the cards, you have to toggle to this modal at the top otherwise the data is killed as per the…