-
User List as Dimension
I have a selection module where a user selects the version & time period to display. The selected values are saved in the module. I have another module that displays the output value based on the values selected in the first module. For the first module, is it possible to add the Users dimension & store different selection…
-
anaplan project experience
Hi, I am starting to build knowledge on Anaplan solution. How do i get real-time experience to build a career? Can someone suggest
-
Delete an element from a list - NUX
I want to be able to publish a form where I can delete elements from a list, currently only creating is available.
-
Bulk copy available for non workspace admins or possibility to add it to a process
My bad, idea already exist...multiple times (not sure how to delete the post) https://community.anaplan.com/t5/Idea-Exchange/Add-Bulk-Copy-to-action-list-to-be-added-in-process-chain/idi-p/40525 https://community.anaplan.com/t5/Idea-Exchange/Make-Bulk-Copy-between-Versions-an-Action/idi-p/40102…
-
How to get value from database into line items
Hi, I have a source module where I have raw data (Rows: Flat list of Row Numbers and Columns: All the line items). Line Items: Funds formatted as Fund List, Trans Type formatted as TT list (Investment, Commitment, Proceeds) and Transaction amount. In my target module I have funds as row dimension and Amount as a line item…
-
Calculation within the list
Hi! I've got a list with few properties. I need to get calculations ("calculation" property in the file attached) baced on the the previous calculated value of the same item in the list. Is there any way to do this. Maybe i should use module? Thank you!
-
How To Capture Current Time?
I want capture current time in Anaplan. please suggest which function should i use?
-
Page Selector across Modules got change even if i change it in any module
Hi, I have four modules with same dimensions but with different Line Items so, when i change my page selector in any module the same page selector got changed accordingly in other three modules also. Is it how Anaplan works or am I doing something wrong? Thank you!
-
Dynamic List
Hi, Is their any way a list automatically change its hierarchy or parent (Active to Inactive) if it meets a certain criteria? Thank you!
-
Time Range Messing up Time Boolean
Hi, I was testing Time Range to calculate items for the current year only. I created an FY20 time range However, as soon as I use the Time Range in one of the modules, a line item in another module starts acting weird However, as soon as I delete the time range (by first removing the references), the formula starts working…
-
Spring Cleaning: Marie Kondo-ing Your Anaplan Model
Imagine your closet transformed by Marie Kondo. Marie Kondo is an organizing consultant that sparked a cultural phenomenon with her “KonMari” method of organization. Her approach is that every item should serve a purpose and spark joy. All items in a Marie Kondo-ed closet provides value. All the shirts, pants, shoes, and…
-
Designating Sales Reps to Accounts Process Questions
Hi, What is a sales quota matrix? What are different input parameters and what is output? Thanks, Sourabh Kulkarni
-
How to hide admin-like result of running a Process
Hi Experts, Please help hiding admin-like view of process running result. Is there any setting for this? Our client doesn't want to see each action succeeded or not. <As-Is> <What my client wants to be>
-
Selective Access - SUM
Hi team, I have an #Employees list with Selective Access enabled. The Source module has the #Employees list with properties such as Department etc as line items. My target module has Department as a Dimension and I wish to SUM on Department but it is returning the value of all the List items with that Department, not just…
-
Urgent!! How to get previous month when production happened?
I have a product list, Month dimension and i can see monthly Production datas in the module . I want to get the Last month when production happened for all the products (let's take one product as example - where production happened on Dec-19, Jan-20 but no production in Feb now when i see the line item Last month of…
-
Hide objects on dashboards/pages based on specific user selection (DCA extension?)
As a model builder I would like to be able to display/hide entire objects on my dashboards or pages based on specific user selections so that I can more dynamically display&hide relevant content to the users. Example : I came across a number of situations where elements of my visualizations would benefit from being…
-
Advice how to structure rolling forecast formula with time element
Hey- I am looking to build on a formula in my rolling forecast. I am having trouble laying out the necessary steps. Percentage Seasonality: Each period in a year (12) has an assigned rate. When I roll my forecast, I need the percentage to take the current forecast month rate / the sum of the remaining forecast periods'…
-
how to identify text
I have two line item, remarks And rem, remarks is Text from data uploaded and then I want to on line item "Rem" just identify "Commission" and "Rebooking and Refund", but the problem is the words in front of it always change, I can't hardcode with mid, or right. how to fix it? any solution. thanks before
-
IF list item 'x' THEN 'do this' ELSE...
I am trying to do an IF statement within a module dimensionalised by a List ('Volumes') which has 2 members: Retails and Wholesales. I need to do a particular calculation depending on if the 'Volumes' are Retails or Wholesales. I have tried IF Volumes.Retails THEN x ELSE y but this not work, giving the following error…
-
Non availability of Map Chart in new UX
Hi, I am not able to see the option of map chart yet in the list of available options in Charts card in new UX. Is this also planned to be added in the next release. Do we have any alternative for the same as of now ?
-
YOY-Growth% Calculation
Hi, I would like to calculate the YOY-growth % between year to year but it seem I fail to calculate the number even I bring the Previous Value also. Thanks, Kiwi
-
Increase the character limit of the MAILTO function
The MAILTO function currently has a limit of around 2000 characters and any greater than this will prevent the message from being opened in your chosen mail app. This is normally fine for standard English alphabetic characters, but can cause issues for non-English alphabetic characters. For example the Japanese character キ…
-
Why is the line item format selectable?
Why do we need to set a format for the line item on creation, can it not be a read-only field and set based on the formula/data. Anaplan knows when we get it wrong, why not just set to what it is supposed to be?
-
Another work around method
Hi, I would like to ask if there are any other work around for the attached issue. Please see attached document for details. I was able to get the desired result using the IF function but I want to know whether there is another approach to it. Regards,
-
Short data for import
Hi Anaplanner, I'm import data like this, but i want to sort data based on color before im import to another after import the data will be like this can anaplan provide like that? Thanks, Panji
-
Import into a List Formatted Line Item
Hi, I am trying to import value(top Hierarchy) from a list A formatted line item to another List A formatted line item. But the import is getting failed. Is it possible to have this kind of reset action to make the selector to ALL(top Hierarchy) by default when nothing in the list is selected by the user. Example: Select…
-
Define Multi Dimensional Level Payout grid
I have a scenario where i have to calculate the commission based on multi level payout grid. Input : End user will be able to define payout grid at any level of dimension by month on month , based on that particular month payout structure. Ex : April month Applicability of Payout at 2 level of list i.e A,B. Assuming Each…
-
SUM vs LOOKUP - Visual Representation
For those like me who like visual aids, I put together a diagram of when to use sum vs lookup in a formula. Hope this helps if you are struggling when to use each.
-
Ability to get to know "Published on" App/Page feature
Since we are moving away from classic dashboarding slowly and NUX being the future of reporting in Anaplan we may need to know where the modules have been published on NUX. Hence proposing an idea of having an ability to get to know about the "Published on Page/App" feature in Anaplan Models. It needs to be precise to tell…
-
Saved views reference
Hi Anaplaners, Is there a way to know if and where a saved view is used? in case I want to delete it. It's easy to determine if a module or a line item is referenced and where. Anything like that for saved views? Thank you -Einas