-
2.3.11.3 Create Line Chart Saved View
Hi -I'm missing something really simple. How do I only show next 2 years?
-
Suggestions on Current User Filter Workaround solutions
Hey, I am using City list and Users Lists as a dimensions with few line items for one module and published that module on to UX page so that user can enter their information in line items. And i have made a saved view on module with filter on amount line item >0 (current user) and User list is on Page selector(but hidden…
-
LAG function
Hi, Question please. I am doing a variance analysis module which line items composed of Last Year (LY) Actual, Actual (current), Forecast, Budget and the variances line items. However, I am trying to have LAG function for the LY Actual line items. I am getting the numbers if I choose a specific month (e.g. Feb21) in the…
-
Level 2 - 2.3.91
Good Morning. Please could you give me some pointers? I'm not sure what this error means?
-
Fill line item with first list member
Hi , Is there a way I can fill up my line item with the first list member in the module ? Thanks in advance for helping. Regards, Tom
-
Time Dimensioned Data to No Time Dimension (Last Non Blank)
Hi Community, I am trying to take data that is dimensioned by two lists and time to a module that is only dimensioned by one of those lists and no time. Module 1: Dimensions: List 1, List 2, Time Line Item: Formatted as a month and calculates Start Date and has it show up for the month that it is in (ex: Feb 20 is start…
-
[SubscriptionHasClosedError]
Hi All, I often get the [SubscriptionHasClosedError] and a red diamond while editing the input cells. Any idea what does that mean? Attaching the error message for reference. Thanks
-
Creating a running sequence of numbers in Anaplan
Hi, Am wondering if there's a way to create a running sequence of numbers in Anaplan. Am trying to create a sequence of numbers that run from 1 to N in columns such that 1 is in col 1, 2 in col 2 ... N in col N. Reason am doing this is to see if there is a way to copy a certain cell value (say a number) from the left most…
-
Add Automated Line Item Reference if a Field is used in an Import/Export action
It would be extremely beneficial and time saving if you could add a reference to a line item that states if it is being used in any import or export action and what that action is. This would be similar to if a line item is used in another line item or module.
-
ANAPLAN level 1 , level 2 and ANAPLAN way
Could someone explain why a fee of $1500 is being charged when there is open course available as in the first attachment by the organization
-
How to enter the time in a line item?
hi! I want to make a module to know the elapsed time. But I don't know how to enter the time in the line item. Please let me know if there is a good way. I want to make it look like this.
-
9.2.5
The formulas are giving me a weird error message
-
10.2.6
I am having trouble with one formula and I am not sure how to fix.
-
Non-Production Data List Items References
It would be great if for Non-Production Data List Items, a model builder could see what references the list item. The only way to do this right now is to try to delete the list item and let the model roll-back so you can see where it is referenced.
-
Order List Action with administrator only
hi, I recommend user to Order List Actions. But, Users cannot do it. Does administrator only use Order List Actions?
-
As a builder, I need to implement more advanced workflows
Description: Would be great to add workflow functionality that includes * Submission and approval workflows * Trigger an event on an action or on approval * Use workflow status in formulas
-
Level 1 13.6.5 Show/Hide Function
I'm trying to build the custom view in activity 13.6.5, however I'm not understanding how to specify which line items to hide (I know to hide all, but Margin) and I know how to open the show/hide specification, but dont understand what I should be selecting in levels or specifying in items to get the view I'm looking for.…
-
User input by monthly and yearly
Hi, Do we have any work around for, User input for forecast version by months and budget versions by yearly, Below is the ss attached.
-
Level 3: Sprint 1 User story 1.3
Dear Team, In User Story 1.3 in Model Build Specification, it was asked to create a DAT05 model in the data hub. But DH Model does not have TR, Do we need to create a TR or I am missing something? @Misbah
-
calculate values from modules with different dimensions but with same ancestor list
Hi, This is my first post so I hope the example will be clear. I have a ‘Customer Hierarchy’ list and a ‘Product hierarchy’ list. Both lists have the same parent hierarchies (see print screen 1 below) Now I have a Sales module with the customer hierarchy as dimension and 2 line items (sales volume, product) The product…
-
6.10.2
When I try to add a formula to SYS07 it gives an error. check photo
-
2.3.11.3 Create Line Chart Saved View - how to build a chart view
Hello, I would like to ask how what is needed in the last task with line chart in this training. I have built a chart, but do not understand how to save it in the view I published it to the dashboard, but it is not the saved view I guess. Please, help. Thanks in advance, Anton
-
9.2.6
I got most of the formulas to convert and are fine but the unit price growth and unit cost growth are both giving me errors.
-
7.2.4
The formulas are giving me a strange error. Please help
-
7.2.2
I am getting errors when I am trying to put in the formulas. Check Photo
-
Create range based on input line item
Hi , Please help/advise on how I can create a condition where we can automatically calculate our rebate based on the uploaded volume. I created a separate list where i define the range and the corresponding rebate. In my calculation module, i need to lookup the rebate based on the volume that was uploaded. My problem is…
-
2.3.8.4 - % by week
Hi - how far off am I this being correct? 'DEM01 Volume Growth Rates'.Growth % * 12 / 52
-
7.2.1
I am getting an error message while trying to map the data.
-
7.2.3
I am a little confused on the mapping. It brings up time but I do not know how to get rid of time as a dimension.
-
Removing Summary Method from Module
I am stuck trying to correct my DEM04 Demand Export Module. I cannot get rid of the time summary columns in the module. I have all summary methods for every line item set to none. I also added a time settings filter for "Months Only?". Yet the half year and full year summary columns still appear in the module. This leads…