-
Pull data into current year from previous year where both are list items
How do I pull data into current year from previous year where both are list items and both are used in a module?
-
Ability of forms to read context selection dynamically to add items to a list
Currently in old UX the "create" action allows you to dynamically read the context and add items to a list. In the NUX, forms do not have this capability requiring a duplicative selection of the context (say cost center as an example) and then the parent of the list item (also cost center). Ideally, a single context…
-
NUX: Import File Selection Type as CSV by Default in Instruction
Hi While importing from NUX, by default it asks the file type to be CSV, but the file I am using may .txt file or other. Although it has no impact on data/action, it may confuse user while running the action. Is there any fix for this? Rahul
-
Secure actions using saved views
As a model builder i would need an added security layer regarding the interaction between actions mapping definitions using saved views that would prevent saved views being changed or deleted once it is defined in an action. This added security would then allow a user to either : - create another saved view if needed for…
-
How to get the nth occurrence of an item using the same list
Dear Community, Hope you can help me with this requirement, this is the scenario: there is a list of products and a dedicated module that allows the user to select the replacement product from the same list. A product can be replaced by one product only, while any product can replace multiple existing products. Referring…
-
FIRSTOCCURANCE should happen based on High number
Hi All, Is it possible to get FIRSTOCCURANCE based on Highest Number? As per the below Example: 1. "PRODUCT A" has the Highest Transaction number- 4,000 in the second Hierarchy(Bucket 2). "PRODUCT A" Will TRUE Under BUCKET 2 Parent. 2. "PRODUCT C" has the Highest Transaction number- 3,000 in the first Hierarchy(Bucket 1).…
-
Stagging List
Hi Team, Please help me with the below requirement, I am using two list items 1. Product List (Stagging List with Hierarchy) Ex: 2) Key Products(Flat List) Ex: Having only one Product: PRODUCT A In the Product Hierarchy list, I am maintaining one attribute called Key Product ? with the boolean format. Now, in Product…
-
Help needed for Lookup formula
Hi I need help with solving for a lookup formula am trying to build in Level 2 Supply Chain Model. Have been trying unsuccessfully to get it to work so need some advice on the solution. Here's the situation: 1. Lookup formula needed for Growth Rate % at SKU Level in DEM03 Demand Forecast module (time in weeks); 2. Growth…
-
Warning when attempting to change a saved view used by an action
No small amount of problems have been caused in our model by someone unknowingly altering a saved view that is used by an import action. It seems reasonable to me to tell the builder who is about to delete, or overwrite a saved view that is used by an action so they can make a decision to proceed or not. Ideally, it would…
-
Accessing Non parent list items from parent list in a module dimensioned with child list.
I have List items of list X- A,B,C,D,E,F List items of list Y- A1,A2, B1,D1 ,D2, E1 (Child list of list X) here item C,F don't have any child . I'm using List Y in a Test module line item1 - displays all list item at child level (i.e list item of List Y ) line item 2- I want to display all list item from list X issue-> i'm…
-
Level 3 Process Flow and UX Design: Redistribution of Sales Target
Suppose if the Regional Sales Executive override the sales target for one account and hold the target for another account, in that case, balance sales target will be re-distributed basis what logic? Does the platform need to re-calculate the redistribution % and then distribute the balance target?
-
LVL2 sprint 3 inv01 correct formulae but wrong figures
Hi all, I spent a lot of time checking all the formulae and they seem correct, but still I got the wrong figures at last. For example, the instruction says "The Confirmed Purchase Order Receipt value has updated to 8,194 is also in Week 3 FY20 column" whereas my result is 8,020. I also found that only the Beginning…
-
TIMESUM cant aggregate(e.g. MAX) time period on time period dimension?
Dear All, According to Anapedia, "Line item to aggregate The value to aggregate over time. The Line item to aggregate argument can be a line item of any format." But, when I try to aggregate time period line item as follows, it returns an error. Example Timesum Date = TIMESUM(Date, TIME.'Mar 18', TIME.'Jun 18', MAX)…
-
Chart graph help - Remove hierarchy total from chart graph
When creating a chart/graph with regards to a hierarchy list, the summary level is included in the chart...this is bad because 50% of every selection is the summary level. For example, in a 3 level hierarchy I want to be able to select the 2nd level and display the 3rd level pieces that make it up. Duramine in the pictures…
-
Filter Full Year
i want to ask, i have module like this the module have 2 lines item actual and budget for the display i used filter for this, but the problems is in the full year the line item is actual, i want to change to bottom up amount, so if on the FY 21 have actual and bottom up amount FY is Bottom up amount and if FY 21 is actual…
-
How to show summary levels dynamically for automatic update of chart
Hi, I have a module with time and client list as dimensions. The client list looks something like this: Economy Clients - Economy Client 1 - Economy Client 2 Premium Clients - Premium Client 1 - Premium Client 2 The line item, for example, is Revenue. I published the line item as a chart by manually selecting only the…
-
Chart in Anaplan Dashboard
Hi team, There is one Numbered List(Site List) and a Line Item(WFC). And we need a Chart(Dot Chart) with WFC >6 and WFC <6 in different colors. Can you please help me on this. Thanks
-
Search in Select source
Please add the option to search from "select and existing source" while defining and import. Currently, we need to scroll up and down and it is tedious if the list is big.
-
REV03 Margin Calculation
Hello, How can I please, desincrement my (Renenues-Cost of sales and margin ) I just wanted to test this , unfurnately, everything is changed. Hello, how can I desincrement this?
-
Failed Order List Action
I have a Order List action that works great in Dev, but fails in test. No error message - Just Failed Action Message. Detail reveals: The model and Workspace ID are the same as the Model where the action resides
-
Enhancement to RANK function when dealing with tied rankings
It would be really useful for certain cases if the RANK function could generate a sequential output when dealing with tied data. Currently, the RANK function can deal with tied entries in 4 ways, MAXIMUM, MINIMUM, AVERAGE and SEQUENTIAL and all handle tied data in a slightly different way but do not generate an output in…
-
MAKELINK Embedding Issue
Hello, I am trying to embed a MAKELINK formula within a list, however the list item I want to embed the MAKELINK into is a function of a LOOKUP, and therefore I am struggling with how to format the MAKELINK. See below: The current List Item title is "Item Name." The current formula for "Item Name" within the list…
-
Establishing Sales Targets Business Process Questions
Generally Business planning starts in last quarter of current year for Annual Budget, how the actuals are handled for last quarter. Is it manually forecasted, copied from last quarter, copied from Previous year Last quarter , copied from Current year Budget?
-
In NUX on worksheets, the ability to publish rollup levels as context selectors
On worksheets within the NUX, there is currently no ability to publish rollup levels only as context selectors and synchronize. In old UX, you could publish any list as a context selector and then synchronize on selection, so that allowed you to sync with any level in the hierarchy. The workaround currently is publish…
-
ifrs 16 lease modification
Hi, I'm building a model to capture and plan leases against the IFRS16 standard. I use a numbered list and have a form to capture start date, end date, initial payments, fixed payments and discount rate. The output is a report by lease showing Interest, Depreciation, Lease Liability. We need the function to modify the…
-
Trying to load from file to module data
Hi Community, I'am developed following dashboard to our end user. My problem is that if I want to load local accounts from a file - all local account will goes ignored state. The module contains a numbered list. My primary key in the module is combination of company+local account number. My question is that how can I…
-
Collect () function with multiple/varying formats
The Collect() function is great for collecting values, however; becomes problematic when trying to bring in a combination of numbers and percentages, and impossible when trying to bring in text or list items. It would be great if the collect formula could follow the same formatting as the source module (i.e. no need to set…
-
Additional Argument for TimeSum
I would like Anaplan to add a new optional parameters for Timesum. The formula would look like this, TIMESUM(x, [f] , [t], [a], [at], [ar]) wherein * [at] stands for aggregation type (simple, year on year). If omitted, default to simple * [ar] is the resulting value in absolute amount or percentage growth. If omitted,…
-
How to count in which number a particular date will come
Hi all, I have a module in which a line item is date formatted and need to find in which week the dates will come as i have to calculate weekly average for all the weeks of a year. Please suggest how to achieve this. Thanks
-
Only column headings to remain without showing period totals
Hi I'm a beginner in Anaplan and need some advise on how to retain just the column heading for a time period say Jan 19 without sub-totals showing for each line item. The sub-totals should be blank. I tried playing around with Summary Methods in Blueprint mode. I could turn off the column entirely by selecting None for…