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 e…
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…
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 writ…
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…
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 a…
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
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 …
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 (capture…
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 …
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…
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 …
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…
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 Ba…
Friends, I am experiencing a very strange case where am importing a boolean lineitem (1 cell) to another boolean lineitem within the same module (1 cell), which has derives DCAs on other lineitems, bu…
Hi Everyone, I'm working on L3 training and feeling stuck. in section 4.6.5 we are asked to build the module that references PY FY19 sales. I was able to do it, but on the confirmation page from anapl…
Hi all, I am having trouble assign territory down to the account level. Here are my modules: Module 1: This is the territory definition module containing the attributes for my territories. In this cas…
I have a module with Day as the time dimension. I would like to refer to the module time dimension in a formula. For example, WEEKDAY(time dimension). So that on January 1, 2023, the line item would r…
I have a module dimensioned by Accounts on the rows, Users on the columns, and 1 Boolean line item which allows users to select certain accounts that apply only for that user. I am trying to create an…