I have two modules with a common text formatted line item Employee ID. The modules are DATA03 and ADM07. In ADM07 there is a corresponding text line item called C4 Code. I want to bring the C4 Code va…
Hi Anaplaners, Is there any way to remove the circular reference from the below scenario? Line item A = Previous(D) Line item B = Input Line item C = Input Line item D = A+B+C
Hi, I am trying to use the IRR function in Anaplan. I have a dummy list of cashflows, with the following dates and net cashflows. In excel, I would just use the XIRR formula on cashflow date and net c…
My current period is set to May 23. I am calculating YTD by taking it in time dimension, but it is calculating YTD by taking values upto May 23 and I want to calculate by taking values upto April 23. …
Hi All, I have a module with native versions that has different forecast versions for scenario planning, one issue that I have is that when I select a different forecast version it shows different out…
Hello, I am trying to figure out below two things for UX pages Is it possible to add status of a running import job on the page. I have user action button that starts a cloudworks integration job. Any…
I have done all formulas and checked my work against the course examples and everything was good until I review the Nutzo Bar_En selecting the Submit Purchase Order Request? I get the following: The e…
My numbers are slightly off for some of them. I am not sure if one of my formulas is messed up, or what the issue is. If anyone can maybe point me in the right direction.
Hi, I am working in a daily module. I want to create a time filter (boolean line item) that checks all the days in the current month. How can I do this? thx
Hello Anaplan friends, I have an issue that I just can't figure out. I need to switch account numbers since our project is getting new account codes. I have a conversion table from old account to new …
I thought that SELECT and LOOKUP where basically the same thing and can be used interchangeably. In the first ss I have a formula where I SELECT a facility. When I try to replace the SELECT with a LOO…
I am curious if there is a way to filter TIME dimension based on USER FILTER. This is the use case. I have module that has ORG dimension and Time. In the UX Page, we have Time as page selector and ORG…
Hi, How can i get the first and last date in my list based on the time it was created? I need to have a boolean to get the : First Date = 05/30 Last Date = 06/15 See below illustration of my data set:…
Hello, I have a question regarding interactions between models and ALM. I have 4 models: Demand DEV, Demand PROD, Supply DEV and Supply PROD, I need to establish a link between the Demand PROD and Sup…
Hi, I'm working on an approval process that should work as follows: Global team take choose if SKUs in my product Hierarchy should be Kept or Disco. Module: OUT000_SKU Planning with dimension: SKU 9 D…
Hello All, I have a situation where I need to do a FINDITEM on a bit different situation. I have one list called Org with codes such as 1001_AX_501, 1002_BX_503, etc. Other list called CC with the sam…
I have a requirement as follows: Module SYS 00: From Version (Version list format) , To Version line item (Version list format). Module 1 : Versions , Cost Center , Line Items . Months In versions (cu…
Hi All, Can someone tell me how can we push development done by one model builder to prod model , when the other model builder's development is under progress and not finished. This is intended in ord…
