-
Create a number sequent in a period column.
Hi everyone. what is the formula on adding a number sequent in one column like 1,2,3,4,5 etc. i tried RANKCUMULATE but it returns all 1. by the way this result was already filtered. thank you.
-
TIMESUM from a Module with time dimension to a Module with a fakeweek dimension.
Good afternoon, I am trying to map the data in day format to a fake week dimension using a timesum. I have a start and end period in DATE format but the formula only gives me a result when this two are the same. This is the formula: This is the source module: With the data imported to day. And this is where I map each week…
-
Adding actions to processes
I am on Level 2 Sprint 1 training, here now I have created actions but now I want to add 1.5 and 1.6 to the processes to 1 Load products and T1.1, 1.2, & 1.3 to T1 Build Product Hierarchies. below is the SS for reference. Can anyone help me with how can I do that?
-
Excel Add-In - Allow user to specify browser used for SSO authentication
Allow user to specify which browser to use as an option in Authentication settings for facilitating SSO sign on — even if default is embedded browser, having the flexibility to select a different option such as updated browser / default system browser will help instances where organizations restrict older browsers from…
-
Error when importing a concatenated numbered list
Hi Guys, Please what might be the issue with this import error, I'm at my wits end in trying to solve this issue. I have created a concatenated unique code from these five fields on this module When I import the Driver Tree Combination into a Numbered List due to the characters is long It throws these error and does not…
-
Dynamic naming line action matching names in Actions
Hello. Quick question. I've implemented Dynamic renaming line items similar to this. The question I have is that I use both modules where I dynamically rename line items (Source and Target) in an action to copy calculated information into a snapshot (e.g.: REP9 into REP09b). Would I need to remap line items in the action…
-
複数のラインアイテムを条件にして、結果List内を検索したい
Test_listメンバー検索 Moduleを使用してリスト内を検索するModuleにしたいです。 検索条件は画像2のとおり、 検索条件1：Text 検索条件2：list: 検索条件2(検索条件2はNumbered list) 検索条件3：Text です。 検索結果ラインアイテムにどの様な関数を検索結果に入れなければいけないかアイデアが欲しいです。
-
Is there a way to change which browser is used by Excel Add-in for SSO authentication?
Using the latest Excel Add-in, it appears this is using an embedded version of Edge browser (version 95.x). Our organization has blocked this browser being used due to the age of the version. Is there a way to change which browser the Excel Add-in uses for SSO authentication so that it will use either system default…
-
Ability to change button color with hex codes
Would be great to have more customization capabilities for buttons in the new UX. First would be changing the color of the button based on hex values. Second would be the ability to change the color of the text on the button itself.
-
Custom Color for Action Button on UX
It would be great to be able to apply a custom color to the process/action buttons that can be on a UX page. Similar to applying colors to titles, table shading, etc. If we are ensuring the user experience aligns with brand standards, etc, having the buttons also align to that color-formatting would be nice.
-
Changing of Text Color based on Accounting Rules, Conditional Formatting, or Combination
Description: As the title suggests, allow for accounting rules as a boolean check box for numbers, so that they are auto-formatted to meet specific guidelines (or a profile that a user creates) such as the text is red when negative with paratheses and black when positive without paratheses. Alternatively, allowing for full…
-
Ability to set a different color for the zero axis line on charts
It would be great to set a different color for the Zero axis line. It would help make it more clear where the chart switches from positive to negative values.
-
Multi-Substitute formula
Hi everyone, It could be very nice to have a new formula to allow replacing several values by others instead of only one with the substitute function. For example, to replace "," by "." and " " by "", the current way is : SUBSTITUTE(SUBSTITUTE([Text], ",", "."), " ", ".") The new way could be : SUBSTITUTES([Text], ",",…
-
Session-Time Out period reduced as part of new login screen roll-out?
I'm aware Anaplan has rolled out a new login screen with automatic detection of SSO. As part of this security release has the session time-out duration reduced by Anaplan? Because users in my org. report that they're being logged out more frequently and constantly as soon as they navigate to a different window or program .…
-
Allow the end-user to set their own language preference for a model within their settings.
Description of the enhancement required: Allow for Workspace Admins to configure the Platform in English but support alias tables that allow end-users to switch between different languages (i.e. English to French, etc.) An example of the enhancement: Allow the end-user to set their own language preference within their…
-
Anaplan Workflow Access
Hi All, I've given access to myself as workflow owner but not able to see workflow tab . Can anyone have idea about that?
-
Anaplan Connect JDBC issues - SnowFlake - (solved)
I have encountered some issues when configuring and running connect script. But I didn't get a specific error message, as following picture : PS: I have configured the snowflake properties files and java, anaplan connect installed etc. Can anyone give me some tips to figure it out ? Thanks
-
Ability to Drill Down into KPI Cards
It would be great to have the ability to drill down into KPI cards.
-
Import Error Issue
Hi Anaplaners, I'm importing a list hierarchy with 3 levels. I have added a prefix "DR1 -" for level 1 code and "DR2 -" for level 2 code & "DR3 -" for level 3 code to the hierarchy items to make them unique for successful import. But yet I'm getting an error "Invalid Parent" Below is the screen shot of the highlighted…
-
Spacing between number formatted line items that include units.
When we format a line item to include a unit, Is there a way to remove the space between the unit and the value? lines formatted to include the USD currency unit look like this as a default: $ 1,234,500 I would like to know if there is a way for it to appear like this: $1,234,500
-
The ITEM function should take a hierarchy as argument
I'm not quite sure why i receive the a/m error. Module: Formula: Error: The formula for 'REP01 Long Term Loan Payable'.Effective Interest is invalid: Effective Interest = IF Is Month Included in Period? THEN IF START(PERIOD('L1 List of Loans'.Date of Loan)) = START(ITEM(Time)) THEN 'L1 List of Loans'.Amount *…
-
Automated Email Notification Capability
I currently have timetables built out in Anaplan with designated users to each deliverable with due-date. I would like to have the functionality to send automated rmeinder emails to users when the due date is getting closr and teh deliverabl has not been completed
-
How to start in a row based on specific date
Hi everyone. may i know how can i start in a specific month row based on my specific month or date. Here is my criteria: and this is what i want to display in m y module: Thank you.
-
How I Built It: Number format converter (thousands and millions)
Hello Anaplanner Community! I’m excited to participate in another ‘How I Built It’ video with a Number Format Converter (thousands and millions) tutorial. This video walks you through how to dynamically update UX grid number formats on all tables and charts. This enables users to have different number formats enabled for…
-
Is there any way to see if a line item subset has been used in a version formula?
We're looking to do some tidy ups in the line-item subsets and couldn't see a way of easily identifying if the LIS has been used in a version formula only. Nothing shows up in the "Referenced in Applies To" and "Referenced as Format" columns. Apart from going into each module and checking, is there any other place/method…
-
License Admin
As an administrator I would like to be able to control the use of licenses across my organisation by applying a limit to each license type. e.g. if we have 20 model builder licenses the system should stop workspace admins from assigning more than 20. I would also like to see something in Tenant Admin which would advise us…
-
Planual Explained - Day 5
Rule "1.05-03": Article 1, Chapter 5, and Rule 3 – “Avoid using List Properties” List Properties are same as line items but have many limitations, so keep it simple and have one place for calculations i.e., Module line items. This goes against P and A of PLANS if you wish to create list properties. Here is how it was done…
-
UX comments per each individual cell
Many of our clients would consider to use comments feature if they could publish them of each cell in a table. Use case: Any outliering value would always be questionable and would require additional investigation of route case including history check and any comments anywhere. Usually it takes a lot of time for RCA while…
-
Ability to input text commentary with text formatting options - New UX
Currently we have an instance were business users are required to provide commentary to forecast data every month, for board presentation. However, if we publish the line item (with text format) on the page using a KPI card the user is unable to do line break or any text formatting, but rather text content comes out has…
-
More dashboard formatting options (bold grid lines)
Description: When publishing a Dashboard, we would like to have the option to modify or customize the thickness of the borders to better segregate the line items from each other. We want the ability to add bold borders, hashed borders, double borders, etc. Benefit/impact: The border must be able to surround the entire…