-
Is there any way i can convert number to text format but still following the number format for comma
Unable to convert number to Text following comma format, Could anyone help me out of this problem? Thanks in advance
-
Rank descending out of order
Sorry I don't have a screenshot for this. I think work is blocking the upload. I have two RANK line items. I need one ascending and once descending. This is the formula for the first one. It's ranking the five items that have the Include in Variance Rank? boolean 1-5. RANK(Volume Weighted Variance Over Defined Months,…
-
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…
-
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
-
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…
-
CIM Phase II - Live
You must be aware that CIM Phase - 2 has gone live today. With the advent of this phase, User admins will be able to * Create new users directly from Admin Console. Remember if the user has been added without assigning to any workspace then the user will be considered as a dormant user, meaning s/he will not have access to…
-
How can I create a dependent drop-down that filters a K3 list based on the selected K1 context?
I want to create a dependent drop-down list within a hierarchy in Anaplan. I need a line item formatted as a list (K3), which represents the lowest level of the hierarchy. The goal is for users to select one of these K3 list items, but I also have a context selector on the page set to the highest level of the hierarchy…
-
Dynamic Workflow Design
Hey builders! I'm tasked with designing an approval process through Workflow and doing this for the first time. This is a CapEx Request approval flow in which CapEx Projects roll up to Profit Centers. Approvers are assigned at the Profit Center level and go through several sequential stages of approvals. Below is my 2 step…
-
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…
-
Do we have any alternative way for TRIM function in Polaris model.
-
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
-
最初に0を下回る日を返す
在庫が初めに0を下回った日を返すにはどうすればいいでしょうか。。
-
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.
-
ディメンションの1項目のみの値を取得したい
上記のように３かつ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.
-
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…
-
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?
-
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…
-
Reducing Extra Space Before List Item Name in UX for Multi-Level Hierarchy
Hi Everyone, I’m working with a 6-7 level hierarchy in Anaplan, and at the lowest level, the list item names are quite long. In the UX, I’m seeing extra space before the list item names start at that level after hiding the other higher level list members, which makes the display less clean. I have already tried adjusting…
-
2.3.11.2 Create Line Chart Saved View
Hi, I can create a filter here in terms of months but I am not getting data for the line chart, where am I going wrong? Please help me on this.
-
Can someone plz post a relevant use case and user story related to investment banking
I have completed my level1 and 2 certification, I am looking to go little deeper into investment banking for an asset management company use cases, modules and lists. appreciate your feed backs and posts bala
-
Can we add numbers of list item in a numbered list by taking input from user?
For Example: If user entered 10 then 10 list item should get created in the particular list.
-
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…
-
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. ..
-
Convert month number to month (month period)
Hi, I am looking for a way to convert a month number (f.e. 1) to month name (f.e. 'Jan 20'). How would you do this? Kind regards, Catheline
-
Convert date type to period
Hi All, I converted this date format into period using this formular PERIOD(DATE(VALUE(RIGHT(Reporting Period, 4)), VALUE(LEFT(Reporting Period, 2)), 1)) How can this date format be converted to period in Anaplan just like above. It doesn't work with the formula above. Please is there a workaround on converting this to…
-
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…
-
Summary module - referencing list with properties
Looking to create a module that provides a summary of a fairly detailed data set that has multiple dimensions, with having originally built this by adding the relevant dimensions to the module and then using a formula similar to the below, just referencing more elements…
-
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?