-
How to edit the display name property of a numbered production list in a deployed model?
I can add items to the production list but can't edit the display name. Ps. It's a deployed model
-
1:1 allocations in dependent Line Items
Hi, im quite new to Anaplan, so I do not know several features. I want an 1:1 allocations from a List to a List/Module Im working with Line Item Dependency, that works so far, that only child items can chosen from the same parent. But what doesn't work is that I mustn't select multiple times the same item. i tried with a…
-
Multilevel Adjustments Removal of checkboxes
Hi Everyone,I am working on a requirement where the customer wants adjustments at multiple levels and we are working with multiple hierarchies so there are a lot of combinations (total level combinations also needed). Now at the dashboard level the user comes in and selects levels from dropdowns and then clicks on a…
-
Multiple approvers in workflow for the same step using a module to define the approvers
Hi, does anyone know of a workaround to have multiple approvers in a workflow for the same workflow task, using a module to define the approvers? Most of you probably know this is possible if you define multiple approvers "back-end" in the step itself. Then you have the option to define if all approvers need to approve or…
-
Anaplan IRR different from Excel IRR results.
Any reason this IRR can't be calculated? In Excel it's properly calculated. However in Anaplan it can't be calculated
-
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…
-
List Hierarchy Update Failure
Hi All, I am trying to update a composite list hierarchy with 2 levels they are both Numbered List. In the source module the List being imported are NOT a numbered List only in the PROD model it is set to a Numbered List. Here is the Parent List and Code is concatenated with _L1 Below is the child list that Rolled up to…
-
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…
-
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…
-
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…
-
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…
-
Look up no working
Hi Community. I have the following couple of models. In green you'll find the dimensions and in yellow the line items. I need based on the Rank from module 1, to pull the geo into module 2. Thanks.
-
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
-
Rank Error with Multiple Dimensions/Lists
I am building a module that is ranking the Cost Centers for the Corporate segment based on the amount of Expenses per Employee (USD) that it has accumulated in 2023 for the Travel & Entertainment account and the Employee Relations account separately. The time dimension includes YTD, QTD, and Month. I want the rank to…
-
Tenure SY07 Sales Rep Details
Hi, I am not really sure why the tenure doesn't show for the other periods?
-
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?
-
Adjustment Calculation- solved
-
Line Item名がすべて表示されない
moduleでLine Itemを作成をしている時に、画像のように、ラインアイテム名の表示幅が足りないので途中までの表示となってしまう。 長いLine Item名を改行してすべて表示をさせる、もしくは表示幅を伸ばす方法はありますか？
-
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