-
DEM04 Demand Export
Can someone please advise what the formula should be? I checked almost all the related discussions and tried all the formulas they suggested. I just cannot get the same result the course posted like this. if I try sum by supplied by or just the final forecast, the result is like this: If I try by location, all 0s. Is my…
-
Import Data Sources / Imports
When in the actions area, there are a couple of different tabs and I've performed some changes previously in terms of updating source models, etc when we have archived old ones, however I would appreciate guidance when looking between Import data sources and Import tabs - I've added elements to Import Data Sources, how do…
-
Boolean to time period
Hi I have a boolean line item checking months from jan-dec 2023 and I have another module which is time period formatted(months).I want a formula that applies to the first module through 2nd module that when a user select months from module 2 then the boolean is checked automatically in module 1.
-
How to populate a line item using formula with correct time scale in weeks.
Future year sales⬇️ Last year Sales ⬆️ I have two modules SYS9 Last year sales in which I have uploaded values by importing data and other module SYS10 FY22, FY23 & FY24 sales in which uplift value or % which is applied on previous sales value to give the future year sales value. In SYS10 module I have a line item Previous…
-
Level 2 Data Hub Historic Volume Importing Data Error
I need some help with these columns mapping can anyone guide me is this correct or not cause it's giving me An error ?? screenshots attached.
-
Avoiding Circular Reference
I have a list of Manufacturing Plants. The output material of one plant becomes the input for the next plant. The cost at which a material is transferred from one plant to the other is the weighted average of opening stock cost, production cost and cost of materials transferred from other plants. Since the cost of one…
-
Options for Override
Hi I have a module of manually entered data that needs to be reviewed and adjusted by an end user. The values often need to be overridden and there is a high possibility of the overridden value being zero. Also the overridden data will often be copied and re-used within the module across different dimensions What options…
-
help
In REP03 Profit and Loss Report module some of line items showing correct results but some are incorrect like headcount and car cost please help to figure the issue .
-
Certified Anaplan Model Builder Course
Hello please provide me the Link for Certified Anaplan Model Builder Corse
-
Using Bulk Copy for Custom Versions list(Production List)
Hi Community Members, We are using the custom versions list in our model and looking to utilize the Bulk Copy functionality. Since a human will not have workspace admin in production, we were looking to create a Bulk Copy Action but it only works on the non-production list. Does anyone else have an alternative solution?
-
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.