-
How to Apply Filter in a module with respect to Dynamic Time filter
Hi, So I ran into a situation where we had provided User specific Dynamic Time filter for Months/Quarters/Year. Now I want to Display only Non-zero Values in my Module W.r.t the Dynamic Time Filter. So, If I select Quarter FY25 then only those line items should appear which has values and when I change the Dynamic Time…
-
Returning a Blank in a IF THEN ELSE statement involving a list
Hi, I am looking for a way to return a blank for an IF THEN ELSE formula involving a list: IF x AND y AND z THEN Values to lookup[LOOKUP: Mapping] ELSE Return a Blank The Return a Blank part is what I am having an issue with. I can't use 0 or "Null" as the format of the line item is a list, is there a way to return a blank…
-
Hello! How to set value as TRUE based on other line item value
Hi everyone, I'm wondering if someone could help me with this. I would like create module like picture below. I have general list "Summary SKU" and "Detail SKU". These general list are not having parent-child hierarchy for each other. Then, in Line Item "Delete Detail SKU", user will check the Detail SKU they want to…
-
Setting up dynamic list of values
Hi We have a requirment as below. We are setting up a General List to track the consumption of hardwares at different sites in the world. There are two columns in this general list. One is Combination which can have three values (Region/Country/Site). The next column is Combination_Name. The idea is based on the value…
-
Case - % Increase on Previous List Item
Hi All, I am working on one use case where need to calculated the value on the basis of previous list item. Module doesn't have a time dimension. But I've created mapping module to identify the previous item. Please see below screenshot for your reference. Final Value = Previous (final Value)* % increase. Can you suggest…
-
Forecast Phasing with Adjustment Issue
Hi All, I have a module that I am trying to do a phasing . (a) Forecast Amount: have an even spread amount as (current best guess) and Total spending amount for FY23 is 22,000. (b) In the Adjustment Line: I want to enter an adjustment for certain months with a new amount (Due to the knowledge of certain month will incur…
-
Comparison with y-1, results from last year
Hello, I'm trying to build a module, where we compare the results with the results of one year earlier. Whey we change the year or date, the columns highlighted in yellow, should automatically show the data from one year earlier. How can I do this? Using a formula?
-
Unbind a flat list or a module by busbars
Please, someone could help me to desconcatenate if it is possible the flat list and if not a module Thank you so much
-
How to create an alternate/Parallel hierarchy
Hi Team, I am new in the Anaplan. Could you please explain me how to create an alternate hierarchy with example? Thanks!
-
Tenure SY07 Sales Rep Details
Hi, I am not really sure why the tenure doesn't show for the other periods?
-
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…
-
L3 Sprint 1 2.2 Baseline Financial Forecast csv file upload
Hi, I am unsure what is going on with my time settings. I have tried every single way to format the time and date but did not work. My time is set as This is my Module looks like This is my csv file date column and format looks like This is my mapping and time format looks like What format should I use that would upload…
-
Difference in digits displayed
I noticed that while exporting or copying the decimal data, the last digit doesn't get exported/copied. Can someone let me know if there is any limitation in the number of digits exported after decimal. As per Anaplan While exporting
-
Line Item名がすべて表示されない
moduleでLine Itemを作成をしている時に、画像のように、ラインアイテム名の表示幅が足りないので途中までの表示となってしまう。 長いLine Item名を改行してすべて表示をさせる、もしくは表示幅を伸ばす方法はありますか？
-
Adjustment Calculation- solved
-
"Unlink revisions created after this restore point" and the DEV is no longer compatible
Hello, I restored my DEV model and selected "Unlink revisions created after this restore point" and now I added new features, but the PROD models shows that the DEV is no longer compatible. Not sure how to fix it. Thanks
-
4.6.5 Sale Planning Model: DAT02 module
4.6.5 Sale Planning Model: DAT02 module In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters For this module, using the LOOKUP function and a Time Settings system module is a more efficient formula than using OFFSET to carry the data…
-
Collection Due Date on Payments Terms
Hi All, I need help on calculating the due date on payment terms, below is the given example: Input Data: Amount: xx Time Dimension: Quarterly Due Date (Line Item): Week 6 FY24 (Format: Week) Report: Amount: xx Time Dimension: Week 6 FY23 Can you please help me on this? Thank you, Lyneth
-
I want to create a list like below but every item in the list has 3 sizes eg 100g 200g 300g
for Eg Nutzo Bar 100g Nutzo Bar 200g Nutzo Bar 300g Raising the Bar 100g Raising the Bar 200g Raising the Bar 300g …..
-
Fetching values from one module into another
I have two modules PROD and TRANS TRANS module is having the dimension of TRANS and looks like this. Two line items PROD ID (List as Product) and boolean (checkbox). Source Product ID Boolean Source TRAN001 PROD001 TRUE TRAN002 FALSE TRAN003 PROD 003 TRUE PROD module looks like this Dimension of Product and line items as…
-
2.4.3 How to Adjust or Override a Previously Calculated Value
In the video for this section (which is great because it explains how the formulas work, btw), using a boolean to tell the system to calculate using a different value is called a "best practice." Why? Specifically, as I see it, the boolean creates an entire line item full of cells which need to be referenced every time the…
-
14.6.2 Add Page Selectors to Dashboard
How do I add Page Selectors? I've deselected the "Show Page Selector" buttons on all three pages, but I'm missing something…
-
What does "Unlink revisions created after this restore point." do?
What does this feature do? Unlink revisions created after this restore point. Go to Model History > Choose a restore point > it pops up.
-
SYS03 ID and G2 not Displaying
Hello could someone help me figure out what am I doing wrong? The values are not displaying and this is causing an issue when referencing for a LookUp somewhere else. Attached is the list, actions and details module.
-
I was trying to import data into DATA03 module. but my lines are not getting populated
-
Level 2 Conclusion - INV01 Inventory Ordering not matching? Anyone please confirm
Hi All, I found that the extract "Check Your Work"(from the link) is not matching with my Supply chain model while doing training Level 2. Downloaded the csv file from L2 - Conclusion shown in screenshot Out of 371 SKUs - Beginning Inventory is not matching for 112 SKUs, while comparing FY20, FY21 totals as shown in pivot.…
-
What is 1)User Journeys 2)Concurrency Scenarios
i want undersatnd what is User journey and Concurrency scenarios . also, if Please explain me in simple words of Sanatizing model and masking
-
Custom Version Best Practices: Sales Forecasting and Planning Models
Hi all, I'd love to hear how you've successfully implemented custom versions in your organization. Please share your experiences or any resources you know of that outline best practices! I've seen two common approaches in the models I've worked in: Most common: Custom versions are a dimension in nearly every module. Most…
-
REV02 Without SUM
Hello, How do I sum the data?
-
getting expected 4-digit year in date/period
Please find the below ss.