-
Making YTG column '0' for a particular line item.
Hello Anaplanners, I need formula to below. I have a module which I am using in management report. Module has values for FY24, YTD, and YTG. But for one line item, 'Opening Cash', we do not need YTG column. Currently the line item just points to the other module to pull the data. May be I need something that makes YTG…
-
Year Value into a Months Module
Hello friends, Can someone please help with this. I have my number in the below source module (profit) by year. I am trying to get FY24 value (profit) into below target module (i.e. 5,999) depersonalised by month: I tried yearvalue() function and it is pulling all 0's. Can somebody please advice? Thanks Kal
-
Composite hierarchies List and Production Data
Hello Everyone, I recently took over the model development from a previous team, and I'm looking into optimisation options. One issue I came across has to due with Composite hierarchies List used for Selective Access, as per the example below: G1 Group - Used for Selective Access - Set as Production Data - No changes in…
-
How can we get the Page history and reverting its changes if desired, like as we do for Modules
Recently i unknowingly deleted the conditional formatting(CF) line item from the underlying module due to this, The CF on the page which is referring to that CF line item is also got deleted. Now, i want to have that CF back on my page. I tried Anaplan's History where i reverted back the module to get back the CF line item…
-
New UX - Conditional formatting multiple line items the same
Hi, I have a dashboard with 20 columns, all of which share the same complex conditional formatting rule that consists of 12 midpoints. Setting up one column takes a little time, and I need to repeat this process for all 20 columns. It would be really helpful to have the option to apply a formatting template to multiple…
-
Do we have any alternative way for TRIM function in Polaris model.
-
最初に0を下回る日を返す
在庫が初めに0を下回った日を返すにはどうすればいいでしょうか。。
-
ディメンションの1項目のみの値を取得したい
上記のように3かつBのディメンションに入力される値のみを取得する方法はありますか? ※3-B(ラインアイテム)全てに100が入る形でも問題ありません
-
Calculate the total interest from the first blank to the last blank in the 'Interest Expense' column
I have a sample where there are loan dates. For each loan date, the nominal interest will be calculated from the first non-blank 'Date of Loan' entry to the last non-blank 'Date of Loan.' The total interest will then be inserted in every non-blank 'Interest Expense' line item.
-
Parent with the same name with its baby item will also map to baby item when Import
Is anyone facing the problem? It worked all right till last week, but I fund it went wrong yesterday. For example, If Importing from Module A to Module B, and both of them applies to Dimension X, which has hierarchical structure. If Parent NNN has the same name as Son NNN, then It become Twice after import to B.
-
Top-Up current period value to specific period
Hello everyone, I would like to know if it is possible to top-up the value of the current period to a specific future period. For example, in my Forecast dimension, I have a value of 1,500 for the November 2024 period and 3,500 for the December 2024 period. My objective is to top up my November 2024 value to the December…
-
Send an Email Notification if a Line Item Doesn't Equal 0
Is there a way to send a notification to specific users if a variance/line item is not equal to zero?
-
A table including both Text and Number format columns
Anyone knows how to create a table including both Text and Number format columns like below? What i know is that, a line item can set to one format only, like set to Number or Text or other type. ..
-
ALM- How and why anaplan saves data in module after replacing list with new subset of same list?
My module contains 5 dimensions, and I am replacing one of the list subset by another list subset of the same list, I have tested it using ALM, but I would like to understand how anaplan ensures even after changing the list subset anaplan preserves input value in that module. I have updated list subset first in test…
-
How to return boolean result to different module
Looking to return a boolean result from one module into another. Is there a specific formula or approach I need to take for this? I'd looked to just link straight to the line item in the module, however this doesn't currently seem to be working. Would it be a problem if they are using different time ranges between the…
-
Polaris - TEXTLIST alternative?
Hi Community. TEXTLIST does not work in Polaris. Planual rule is to avoid using it, however, there are times when the functionality is needed. Has anyone got an alternative or workaround to achieve similar functionality
-
How to Use Lookups from Multiple Modules with Different Dimensions
I have three modules with different dimensions: Product Details: Dimension: 'Product' Line Item: 'Dispatched Qty' Formula I used is : 'Order Import Data'. Dispatched Qty [LOOKUP: 'Order Import Data'. FIND_PRODUCT] Attributes Allocation: Dimension: 'Allocation ID' Line Item: 'Dispatched Qty' Formula is : 'Order Import…
-
User rights - summaries
I have access rights set for a user on customer list and on product list. Because they are both under hierarchies, once I set their visibility in the lowest level list of the hierarchy, the user can't choose a total to view all the customers/products. how can I still provide them with a summary?
-
Column type issue
There are some columns, like 'ReportingPeriod' and "Curr_Q" should be Number type while "Comments" field should be Text type. In this case, any suggestion how to set the line item format? For example, the first line item "Global Allocation", what format to be set? either Number or Text is not correct I think. Thanks.
-
Best Practices for Optimizing Anaplan Model Performance?
Hi everyone, I’m working on a fairly large Anaplan model that’s starting to experience some performance issues, particularly when running complex calculations and data imports. I’ve already tried reducing cell counts by removing unnecessary modules and optimizing sparsity, but it hasn’t made as big of an impact as I hoped.…