Hi Team, Is there a way I can use Previous but won't affect my previous or succeeding month? Example: Jan 1 - 1 Jan 31 - using Previous I will get 1 Feb 1 - 0 (should not get my result in Jan 31) Feb …
Hello, I'm trying to configure the view below using the Time Settings and/or Time Lookups module. I've tried multiple things, but haven't been successful. Can anyone provide guidance on how this can b…
Level 2 Completion I have completed and passed all the exams of Level 1 and could some one let me know web link for Level2 exam and required information. Thanks Narasimha
Hi , I have a module with list of employees who belongs to different countries .I have created a user filter on country selection . Now when user selects a country ,the list of employees shows the rel…
Hi, I have a module below, a list (transaction date) on the rows and time period on the columns. Is there a way to do dynamic aggregation vertically based the list transaction date? For example, I wan…
I want to create a new filed and a logic where the input will be project name which is a combination of letter and and digits. The new input field should replace '0' in the 3rd place of the project. E…
Hi all, What's your opinion, should I ever use PREVIOUS(ITEM(TIME)) function when ITEM(TIME) - 1 does the same thing? Best Practice says it's not recomended to use PREVIOUS() due to low performance. I…
Hello, I'm trying to configure the view below using the Time Settings and/or Time Lookups module. I've tried multiple things, but haven't been successful. Can anyone provide guidance on how this can b…
I'm interested to see which is the better performer and also, subjectively, which function is more 'readable': SUM or IF, in the following scenario... Consider that you are building a model for an int…
Hi, I have Months as a numbered list. The number of items in this list is calculated based on user input. Each time the user changes the input, the list should be deleted and items should be created b…
While setting up the Dynamic Cell Access based on user roles we would have to resort to a workaround where we would create a list of roles and based on that we would setup the DCA. However, if the ROL…
Hi, I created a module with exchange rates data for each month. Then, I put summary as : sum, time: closing balance. But as I only have data until Sep 2020, it puts 0 for FY20 and 21. So, I would like…
Hi, I have a requirement where I want the user to select an item from the numbered list formatted line item and then copy the same item in rest of the rows, but this doesn't work and throws the error …
Hello all, I am looking for a solution wherein we set a specific time period ( 6 months) for certain users and post 6 months their access should be automatically terminated? is it achievable ? Thank y…
Hello ! We would like to produce dynamics benchmarks with the new report It could be powerfull if we have the hierarchy filter option in context as it already exists for boards.
Hi All, Need help with how the process to follow the deletion of line items in the List. H1/H2 is the List within that we have 3 line items called Total(Parent), H1 and H2(Children) it's summing up to…
Hi, I have below two modules: Module CAL04: Page: Business Line, Line Items, Column: Time, Row: Transaction month Module DAT06: Page: Business Line, Column: Periods, Row: Line Item I want to have NCO%…
Hi, For your assistance please. I would like to ask how can i lookup child which is on level 2 and the parent is on level 0? Hierarchy Target Module : Dimension : L2 cost center Source Module : Dimens…
It would be great to be able to add collapse cards on the boards - similar to Additional Insights- . It will allow the view to be clean but will also house the information to be accessible without goi…
@Misbah 1. Shipping Costs = Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] Is there any problem wit…
Hello, Im currently in Sprint 3. When I was publishing the values to a dashboard, I noticed My Safety Stock Exception value was very high(Screenshot attached) On digging deeper, I found out my Ending …
Having the flexibility to have the formula bar in the new modeling experience expended at the top versus jump to the bottom. In addition having the ability to move the formula bar around similarly to …
Description: The ability to trigger the “Reset” action/button in the list configuration tab (for numbered lists), using Anaplan Connect to automate this process. Example of Enhancement: Anaplan Conne…
Guys, I have this issue with the mailto functionality, wherein I am picking up user names for "TO" from the line item 'To', which is formula driven and is picking up more than 1 user. In a particular …
It will be very convenient to setup width value of a window where user selects a list item. Or to make it always be as wide as the longest list item name plus width of tabbed white-space due to hierar…
The New Modelling Experience Button/Switch/Toggle turns off automatically if a user logs out and logs in again. This behaviour has been recorded in Normal Browsing Mode of Chrome & MS Edge. However, i…
Hello, I have a line item in my model - X with a list format. This line item uses the SUB list (as format). In another line item - Y I need to refer to a specific member from X , how should I do this?…
Would be nice if I could quickly select an import data souce when setting up new import based on the most recently created saved view. The suggested source item can be based on whatever the last sourc…
Use the native capabilities in CloudWorks to distribute data from the Data Hub to Spoke models, or between different models in the platform, any time you want with its model-to-model import functional…
