-
ifrs 16 lease modification
Hi, I'm building a model to capture and plan leases against the IFRS16 standard. I use a numbered list and have a form to capture start date, end date, initial payments, fixed payments and discount rate. The output is a report by lease showing Interest, Depreciation, Lease Liability. We need the function to modify the…
-
How to count in which number a particular date will come
Hi all, I have a module in which a line item is date formatted and need to find in which week the dates will come as i have to calculate weekly average for all the weeks of a year. Please suggest how to achieve this. Thanks
-
Only column headings to remain without showing period totals
Hi I'm a beginner in Anaplan and need some advise on how to retain just the column heading for a time period say Jan 19 without sub-totals showing for each line item. The sub-totals should be blank. I tried playing around with Summary Methods in Blueprint mode. I could turn off the column entirely by selecting None for…
-
'SYS08 Employee Details'.Region
I'm having a little difficulty in the exam on activity 6. I understand the sum that needs to be completed on region and role, however I am having difficulty updating the region on the SYS08. Am I going down the wrong path or how should I think about updating this region in the module? Thanks,
-
Child with several parents in hierarchy
Hi all, I would like to create a hierarchy with 3 levels of lists: 1. Entity > 2. Direction > 3. Department. In the level "2. Direction", I want items to belong to several Entities. It is the same for Department level (a Department can belong to several Directions). I need to create a data hub and then a spoke model. In…
-
Create two lists from one existing list
Hi Team we have a list with list items as 20180101,20180101.01,20180101.02. Now I need to create two different lists as parent child hierarchy from existing list. If ".01" is there at right hand side(20180101.01) then it should reflect as "Branch1", If ".02" is there at right hand side(20180101.02) then it should reflect…
-
List and Modules
I am Working on a Test Module dimensioned with List B which is child of list A; There are some list items in List A which doesn't have any child. In Test Module I have created two Boolean which 1)checks child is present 2) parent with no child and I have created 3rd Boolean which will be true when 1 or 2 is true, but I am…
-
Taking an average of specific Quarters, like all Q1 or all Q2 over many years
Hi, I'm attempting to generate some historical trends to drive future projections. In doing so, I have % Weekly over a 13-week period (one quarter), and I have this over many quarters. I'm trying to capture an average of all Q1 % weekly values (such as FY18 Q1, FY19 Q1, FY20 Q1, etc.), to predict a likely quarter…
-
User filters and Top levels
Hi, I want to set up user filtering for a module, with Customer and sub-brand, I have a user filter module, and system module with the appropriate line items I use the system module as a filter and this all works as expected. I want to be able to choose a specific customer and a specific brand or a specific customer…
-
Logic Line item availble two function (Input and Formula)
Hi, Everyone. I have a question about logic Anaplan, I have a module that will create an item that can contain input and formulas, for example, for example, a period that is less than the period parameter will be blue font or input by the user and more than the period parameter will take a logic formula. Has there been a…
-
Item deleted from List
I have accidently deleted an item from a List in a Module. So the item still exists in the List but not anymore in the Module in which that List has been used as a Dimension. Any clue how I can get the item back as a part of the List in the Module? thanks.
-
Backlog and Lead times
Hi, I need to calculate a backlog for per product per day. I have a module with Factory open days and closed days and a module with lead times by product. Volume gets sent to production (factory) and then I need to take a lead time calc for the products. The trick is that to work out how many future days in a row the…
-
SET CHECKBOX value through a given condition
Hi Everyone! There is a way to set one line item boolean to TRUE to specific condition and make it editable for other condition ? On the example below, "Main process" is checked i need to check the "Process Comp" on the same line and make the above enabled to edition (check/uncheck), is it possible ? I'm trying to set…
-
Count Function
Hi, How could I count days by 1) weekday type and 2) Actual data or not. Ideal result would show X day for "Weekend" for Actual data, Y day for "Holiday" for Forecast data.. etc. * Index is a "Day" list from 1 to 31. * Column "Weekday" and "Actual data" are manual input. * "Value" is a supporting column. Feel free to…
-
Unable to RANK from Lowest Amount When the Item Is Only One
Hello, I hope you're all doing well. I have this problem that's preventing me from proceeding on to the next steps. I'm trying to rank the basic salary from lowest to highest, by position. As we all know, even if employees have the same position, there are instances that they don't have the same salary. The idea is, I need…
-
Is there a way to hide zero value line items?
Hi All, Can someone help me how to hide zero-value line items in a model or dashboard (within the dimensions). regards Sudhir
-
Forecast Data using TIMESUM function
Hi Team, I have one situation, where I am calculating a Line-item in Forecast scenario using Sum of Last 12 months (from the Current Period). Need your inputs to help with the below model design. Scenario 1: Current period = Jan 2021 Actual Version = Jan 2020 till Dec 2020 Forecast Version = Jan 2021 till Dec 2021 (i.e.…
-
DCA based off of a user in a module
Hi all, Wondering if anyone knows of a way to matchup the user from a module with the user list used in the DCA module. Obviously you cannot lookup based off the user list, so wondering if anyone has a workaround.
-
Finding the next non blank field
Hi, This must be simple but it is driving me mad What formula do i need in the Next Non Blank line item to find the next non blank date? Thanks
-
Formula using Min Function
Hi, I'm trying to replicate this Excel Function in Anaplan. I want to make sure my Anaplan Function is picking up all the values for my Line Item from the begging through the end of the month, and not just the beginning and end month numbers. I have the Formulas below. Please advise. Excel Function…
-
Finditem in Subset (Works!)
In a prior post, I'd asked if there was a way to use the FINDITEM function to determine if a list item is a member of a subset. The answer at the time was no, but you could create a line item with an Applies To on the subset, and set the formula to TRUE, then you could create another line item with Applies To on the full…
-
Confused on how to use Min Function
Hi, I' trying to use a Min function to take the min Account Balance in a month. This is the function I thought of using but it is not working. Both are formatted as Numbers. 'Y02 Accounts'.'Closing Balance (01)'[MIN:'S01 Time Settings'.Day # of the Month] Thank you
-
Quarter value as numeric numbers
Hi All, Required a quick help in getting the quarter number as numeric format. For example in attached screenshot, need to get the value for second line item as entered. All Q1 Months should populate with numeric number 1, all Q2 should be populated with number 2 and so on.... Quartertodate() function gives a numeric…
-
Boolean between two dates
Hi, I have a module with three line items: "From", "To" and "Any", which are all Boolean formatted. I also have time as a dimension. "From" is just true for one month, which comes from another module, and the same goes for "To". My problem is within the "Any". I want that to be true for all dates between the "From" and…
-
Capturing uploading timestamp in a line item in module
There is a requirement where, when we are importing data in a module, the current timestamp when the file is uploaded in the module should capture that time in line item.
-
Need support with Time Management using DCA
Can anyone help me what's the best way to identify - Current Year Current Quarter, Current Year Previous Quarter, Previous Year Current Quarter using DCA and Boolean.
-
Level 3 Sprint 2 Section 4.5
Hi, Section 4.5 says to check my build on the Accounts Exception UX. I am not sure if there was an activity to build that. Am I supposed to build the UX pages basis the mock-ups we created in the beginning?
-
End of Month Totals in a Module.
How do I get end of Month Totals to show in a Module that is has a daily time dimension?
-
Circular Reference with CUMULATE
Hi All, I am trying to solve an excel model in Anaplan where my current value is a calculation of the cumulative of previous values. The calculation works fine in excel but I am unable to break this down in Anaplan. I am adding the screenshot for the logic of this model below. Any help or suggestions would be helpful.
-
P3 SKU 0 Failed Invalid parent
Hi on the Level 1 model building exam, I am trying to import the SKU csv and I get a message saying invalid parent and I dont know why. Wold you mind helping me ?