-
Need help connecting text values between two modules
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 value into DATA03 into the C4 Connect line item based on where the Employee ID line item matches between the two modules. What…
-
Remove the circular reference
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
-
Calculation based on the cell value
-
Calculation Cell value based on the other
-
XIRR Formula
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 cashflow, but in Anaplan, what is the best way to add the redemption value in the current period and perform the XIRR…
-
Regarding YTD
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. How should I do it ?
-
Different Numbers after selecting different version
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 output than the others. What might be the reason for this and is there any workaround to fix it? The output is expected to be…
-
UX Page ability question
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. Anyway to show status of the job like its running or is complete? Also I notice that once the import is finished, the data on…
-
3.3.5.3 Check Your Work - I don´t understand were I´m wrong.
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 example given in the course says that the confirmed Purchase Order Receipt for Jan20 should be 8,194 but I get 8,396 (same as…
-
3.3.5.3 Check your Work
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.
-
Boolean that checks all the days in the current month
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
-
How can I go get an old account number?
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 account. (100 - 100100) I created a list for the new account and Properties module. Now I want to have a reverse lookup…
-
I can only use SELECT and not LOOKUP
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 LOOKUP, it give me an error. The second ss is an image of the list hierarchy. Why does this happen? Is there anything I can do…
-
UX Time Filter based on user selection
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 in rows. There are some line items, for example Active/inactive, code, member name, etc. I would like a field to be…
-
Get first & last date in list of data
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: Thanks in advance for helping. Tom
-
How to set actions between PROD models (via DEV models)
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 Supply PROD models. My question is how shall I set the action in the Supply DEV that will then be deployed in the Supply PROD…
-
Import action not getting filtered
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 Digit. Global team click a action to send data to Regions: Module used: INP000_SKU Planning Global Approvals; dimension Brand…
-
FINDITEM(Manipulation)
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 same set of members, however, the codes are 1001, 1002. In order to map them, I need to do a FINDITEM with some twist so that…
-
Variance
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 (customized list) , I have Actual , Estimate and Variance. Line item Cost , Cost Final In the line item Cost Final, I want to…
-
Regarding ALM
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 order to meet the urgency of the requirement. Thanks in Advance.