-
How to make text rollup's at top level in hierarchy as blank and visible at other levels.
Hi Everyone, I am looking for a solution for text rollup's in summary in hierarchy. I have a model with 4 levels of hierarchy. In a module , I am using L4 Product list as Dimension. There I have added a Text Format Line item called " Client name" with summary as First Non blank. It contains formula to Identify which…
-
How will sync option work in dashboards
I would like to understand how will the sync option help to activate all the Grids with one selector
-
What is the difference between Time sum and Moving SUm
Hi I want to know what is the difference between Time sum and moving sum. Scenarios that we use them individually
-
Importing a list from Hub into Spoke Model
Hi Experts, I have an import set for a list from data hub to my spoke model. My concern - the list items in the list on Data hub keeps changing based on the updates made in the upstream system. As an example say in Nov - I had the id ABCD1 as a list member in Data Hub and also in Spoke model when data was pulled. Now in…
-
Error Message: Mapping have a common LIST format
Hi all, I am trying to assign the territory to the accounts that matches the attributes. However, because I am using the same list for my Product L2 and Product L3, I am getting the error below. I understand that this is due to my line item format be: build a product list hierarchy is not an option because I want the…
-
Level 2 - Sprint 1 Activity 1.3.6.4 Create Import Distribution Center Details Saved View
Hello, For the SYS07 Location Details I believe we need to have some formula to populate this table. This is a little tougher because these are flat lists that are not linked via hierarchy. Can anyone guide me help how to generate the country, region and distrubtion center in SYS07 ?
-
how to check of the month of a month formatted line item
Hi I have a month formatted line item in one module, how can I get a boolean line item to check off in that month in another module? In my SYS65, I have a month formatted line item "MOB to time" For example the value is Mar 24. How can I get Mar 24 to checkoff in my C86 module? (both are dimensioned by credit and turn)…
-
5 Years Planning
Hi there, I am trying to build this kind of P&L view : where 2023 FY figures come from another module where the line items are planned on a monthly basis. The idea is to forecast every year after 2023 based on Y-1. Meaning that the revenues of FY 2024 will be = Revenue FY 2023 * x%, Revenues of 2025 = Revenue FY 2024 * x%…
-
Selective Access and picklists
Hi, I have set up selective access on a list and limited the user to one list item. This works as from the context selector at the top of the page, they can only see the one list item I gave them write access to. But when they access a user based picklist for that list item, they can see all the list items. They are able…
-
Data Discrepancy between Data Hub & Spoke Model
Hi Guys, For an import from Data Hub to my spoke model for a module - I am seeing additional entries in my spoke model for a certain month that do not exist in the data hub. I looked at the history to see if someone manually added the entries in the spoke model but that doesnt seem to be the case. Neither of the models or…
-
Export ignoring show/hide
Hi guys, I have created a saved view in one of my modules. my module has 4 dimensions + line items. Time, Cost center, GL account and version. My saved view has selected a few versions, cost centers and GL accounts. I use tabular single column for my export as I want all dimensions to be columns and only a single line item…
-
Summing values for a year
Hi, I have a line item which is equal to (Monthly income)/(yearly income). How can I reference the yearly income (or calculate it), I have the monthly income as input. Thanks
-
Production capacity calculation
Hi, Good Day All. Does anyone know how to build the calculation modules that calculate a Factory’s production capacity. This is the formula I am using: Production capacity = number of machines*number of working hours*number of working days*number of shifts*line efficiency. Usually, they work five days a week (From Monday…
-
Compare numbers in different modules
Hi I have a module with employee details to calculate their monthly payout. The payout is based on the % attainment stored in the same module. The % attainment need to fall in a defined range (captured in a DAT module) to suggest the payout %. For example the DAT module is as given below (not dimensionalised) The other…
-
Formula to calculate based certain items in a dimension
I am having trouble to create a formula to calculate something on selective items in a dimension. Simplified example is as follow. 1. Products A, B, C and D defined in a list 2. Clients 1, 2, 3 and 4 in another list 3. Production costs calculated at the client level based on the products (any and all) they have Now I need…
-
Sum based on Boolean
Hello, Hopefully a simple one. Our P&L has 50 cost centres, each of which have staff costs assigned. In a separate module I want to bring in the staff costs from 15 of these - is there a simple way to do this, for instance by having a separate module with the cost centres included and a boolean line item to determine which…
-
Production Data - Top level Can be Changed?
I have a scenario as follows: I have a List named "Product L1" which has been marked as production data. While I understand that structural changes can still be made to a list that has been marked as production data, I have noticed that the top level, which cannot be changed if the list has been marked as production data,…
-
Lesson 6.6.4
My module looks identical to the example, except for one additional "YTD" column. Can someone advise how to get rid of that additional column?
-
A line item format as "No Data" can be used in an import action?
Hi Guys, I have an action to clear data in target module. The format of line item in source module is "No Data" and formula is blank. And the format of line item in target module is Boolean. I want to make the value of target line item as FALSE. Does it work when I run the import action? As my experience source and target…
-
Anaplan formula to Lookup Balance Sheet description from mapping table module
Hi Anaplan Community Please see email attachment with all details for my question. I have an “Account Major Properties” module with a line item of “B/S Line Item” where I want to populate the valid Balance Sheet line name, from the list “Balance Sheet Lines – NEW”, based on the Account Major (e.g. GL Account) contained in…