-
How to add cell values for previous 8 months data only
I have an line item 'Amount' with data values. second line item(months applicable) which is boolean checked for only 8 previous month of current month. I want to add the values of these Boolean checked months only to be summed. Can I please get some guidance here please? Regards Asha
-
ABS formula
Hi, anyone who can help on formula "ABS"? I need to get the absolute value of the line item, but Anaplan seems to round off the item. Any notes on this? Thank you. Below is the screenshot for sample:
-
Process builder in anaplan
Hi, Can anyone give brief about Process builder and its task in anaplan. Thanks, Keerthi Malathkar
-
How to get the previous period of current period
Hi, Can I please get some reference how to get previous period of current period. PERIOD(CURRENTPERIODSTART()) gives me the current period I,e Jul 17 but I need Jun 17. Previous(period(currentperiodstart()) which is not working.
-
How to add cell values for previous 8 months data only
I have an line item 'Amount' with data values. second line item(months applicable) which is boolean checked for only 8 previous month of current month. I want to add the values of these Boolean checked months only to be summed. Can I please get some guidance here please? Regards Asha
-
Can we create alias names in anaplan?
Can we create alias name for time,versions dimensions in Anaplan?
-
Hierarchy change in planning years
How to save the data of the previous years when we want to change the list items hierarchy in planning years? Other than creating a copy of the model, is there any solution??
-
Formula for the Hierarchy
Formula for the Hierarchy
-
Sorting Users in Anaplan
Hi Guys Does anyone know a way to sort users in anaplan . I am talking about the User setup / Access Area . I don't want to delete users and re-add sorted lists as it will generate email notifications to users . Cheers
-
Referencing Model Calendar in Formula
Hi all, I am trying to see if there is a way to reference the model calendar in a formula. I want to return the fiscal year that the week is in. e.g Week 1 FY19 Result would be FY19 The intention is to use this to lookup other data, E.g IF Fiscal year = FYxx then... I have a Timing - Calendar Module (screenshot below) if…
-
How to read only 8 previous months data of current month.
Hi, I have created a master time dimension setting module where my current month(Boolean line item) is selected as June 18. I want all the 8 previous months value to be read by a second line item from an input module(second module having data for all period) Amount(line item) should have the values of only 8 previous month…
-
Getting data by line item into a dimension and generalising a complex formula
I want to calculate some values in my "Forecast" using a formula that is almost the same for each value. The only difference is that each row in the "Forecast" module gets an initial seed value from a different line item in the "Base Data" module. The formula I want to use is actually a lot more complicated than shown in…
-
Using different versions in formula
Hi, I'm trying to create a formula that has 2 different views of forecasts. My current and my previous. Current is pulling in fine. Struggling to create a formula that says Fcst V2 = Previous months Forecast. So if Current forecast is p4. I want my FCST V2 to equal my p3 Current forecast.
-
If statement not reading periods prior to forecast start
Hi All, I was wondering if someone could help with below. if statement not reading dates prior to forecast start period. Forecast start period is Mar -19 Below should return 0 rather than Mar -19, why is the if statement not reading the first part of the statement? What do I need to change to get it to work? IF…
-
Custom Filter
Hi Experts, I have a requirement.i am confusing how to resolve this kindly help on this. In One module Row Axis - Product and Customer lists Column axis - Lime Item and time lists Page Axis - Measure list There are 5 line items. For each line item i want to saw different time periods that also based on user selection. For…
-
Equivalent to LOOKUP Function but for a Text formated Line Item?
Hi All, I have an Import Module which has a Number and a Text Line Item. I have created another module with the Dimensions Provided Service and Cost Centre and in the Import Module created List fomatted Line Items for those 2 Dimension. I have successfully pulled across the Number formatted Line item from the Import Module…
-
SUM on non-shared Dimensionality
Hi, I have a Target module which is Dimensionalised by Line Items and Time and a Source module which is dimensionalised by a numbered list and 3 line items (1 is direct input and 2 are List Formatted (1 being Time, 1 being Line Item Sub-set of the Target module Line Items) In my Target module I wish to return the Direct…
-
Time Formatted Line Item - Custom Time Range
Hi, Is there a way to use Custom Time Ranges when creating a Time Period formatted Line Item? I wish to display only a certain number of periods as a selection option but currently all periods are the default Many thanks Mark
-
Look for similar Item
Good day! May I ask for any ideas how can I execute a search for similar items from a list. I have a list of stores with several properties such as type, target market, population of location etc. and if I add a new store, I want to assocoate the new store to an existing store with the similar or nearly the same…
-
Job scheduling optimiser user case
Hi, Has the Anaplan optimiser been succesfully used for a job scheduling problem? Objective is to minimise the time taken to complete a set of jobs. Constraints are: 1) We have a list of resources who can each supply a maximum amount of time per time period. i.e. Time spent by resource A in period X <= Time available for…
-
Display selected item from a list for input and calculations
I developed an module displaying Rep, Customer and product. This required to enable planning to be done at Rep Level, Customer and Product levels. This will be used to input unit volumes per product / customer and Rep The easy way would be to have the total product list but each Rep are responsible for selected product and…
-
Filter w.r.t Different user access
I applied a filter on a module in a dashboard based on a boolean formatted line item. The filter works fine for one access. But when we switch to another access but with the same role, the filter doesn't work for that module though the "filter" option shows that the filter is applied. To make it work, we delete the rule…
-
Referring Property values of one List from another List
Hi Team, I am trying to pull the values to my numbered list property from another flat list property. Here L1 and L2 are my lists and A, B, C are my properties as below. I need to pull data to property B (text or list formatted) from property C. L1 (numbered list)A (list formatted to L2)B L2 (flat list)C (list formatted )…
-
Remapping Line Items between Modules
Is there a best practice way to remap line items between modules? What I mean by this is taking a set of line items from a module and remapping them to another set of line items in a module, as per the screenshot below? My use case for this would be to summarise P&L lines or to reclassify line P&L lines into a different…
-
Line Item Date Format
Hi, I am developing a model in India and the client is from US. I created a line item 'Creation date and gave formate date where they can select particular date from the drop down. The format of the date is DD/MM/YYYY. But client wants it in MM/DD/YYYY. Can we do it directly? I know a work around of making it text and just…
-
review query 299
Hi, Can people in one region can book a slot for other region for 299 model review? for examaple, india consultants can they book review in emea or americas?
-
Linking a set date to a specific time range
I spend the last 2 days trying to dynamically linked a specific date (specified by a user) I created a module to have visible the versions, country and initiatives (as my lists) and of course the line cost items and calculate the monthly charge per cost line item per costing type based on the elapse time between start and…
-
API Usage Limits
Does anyone know what the Usage Limits are for the Anaplan APIs? Also, is there any max of concurrent calls for the available APIs?
-
Dependent Dropdowns - Many to Many
Is there a way to enable a many-to-many relationship on dependent dropdowns? If so, how do you do this? To provide some context, I have two lists: * Departments * Employees Employees can belong to many departments. (Currently have a module which assigns employees to departments using two dimensions, employees and…
-
Delete multiple items/rows from list.(more than 5000)
Hello Members, I wanted to delete more than 5000 rows(nearly all) from an independent numbered list but at the same time wants to save the list and its properties. If we delete any items/row from the list containing more than 5000 rows, it says to select and delete and by this only one is getting selected and not more than…