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 sit…
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 d…
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 …
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? D…
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 …
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 peri…
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 hi…
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 ch…
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 - Premi…
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
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.
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?
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 act…
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, MAXI…
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 MA…
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 Pre…
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 syn…
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 ra…
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 num…
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 lis…
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 …
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 …
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…
I'm having a little difficulty in the exam on activity 6. I understand the sum that needs to be completed on region and role, however I am having difficulty updating the region on the SYS08. Am I goin…
Hi all, I would like to create a hierarchy with 3 levels of lists: 1. Entity > 2. Direction > 3. Department. In the level "2. Direction", I want items to belong to several Entities. It is the same for…
Hi Team we have a list with list items as 20180101,20180101.01,20180101.02. Now I need to create two different lists as parent child hierarchy from existing list. If ".01" is there at right hand side(…
I am Working on a Test Module dimensioned with List B which is child of list A; There are some list items in List A which doesn't have any child. In Test Module I have created two Boolean which 1)chec…
Hi, I'm attempting to generate some historical trends to drive future projections. In doing so, I have % Weekly over a 13-week period (one quarter), and I have this over many quarters. I'm trying to c…
Being able to adjust column widths in Blueprint mode would be great. Rather than having to open an 'Applies to' menu, format menu, or copy and paste notes, and formula references, it would be great to…
Hi, I want to set up user filtering for a module, with Customer and sub-brand, I have a user filter module, and system module with the appropriate line items I use the system module as a filter and th…
