-
Need Formula help
Hi Please refer the screen shot attached. Within a parent,I want to sequence the column 'Structure Type' based on each unique Job Name.For example, for Job Name 318317,I have marked 1 and 2 for 317542. Need to know how to setup the formula for the column 'Structure Type' for this requirement. Thanks Regards Prabakaran
-
Formula assist
Hi, I have 2 lists: 1) LIst of Funds (P3) and 2) List of Fund entities (P4) whose Parent is P3. I also have a P3 details module that lists out the fund currency for P3 Funds. My issue is, I have a module (P4) which I'm trying to pull the fund currency from the P3 details module - i've tried using PARENT(ITEM etc, but…
-
Line item formatting
Hi, Question please. Would like to ask if it is possible to have two formatting in one line item? for example (see ss below), the columns are line items and the rows are LIS. The GLA for 2018A and 2019B (9% & -3%) are percentage change variance while the Lease out rate formula is the difference of 2018A and 2019B (4p%ts &…
-
Formula error - dimension issue
Hi, Can someone assist with a formula error I'm receiving? I currently have 3 modules (see attached), and in the third module, I'm trying to calculate the number of meetings by entity and product. The error message I receive is: Dimension of mapping used for aggregation doesn't match any dimension of the source. My formula…
-
Ratio formatting
Hi, Question please. I am trying to format the percentage change (in red box) with suffix of "pts" but when I click the percentage the suffix is disabled. I tried also using the Ratio in the Summary Method but still the same. How can I fix it? Thank you.
-
Extend 10M item limit on RANK and similar functions
Description of the enhancement required: Raise limit on RANK function while maintaining adequate performance. How would it help your business process: We've been seeing more incidents where customers are hitting the cap placed on RANK and similar functions.
-
Formula Error
Hi, I have a list of 'Brands' which is a production list. I know that 'select' function does not work with prod list members however, it should work with the list top member/ highest level . But when I am using it with the highest level i.e. 'All Categories' I am getting an error that the list member or version is not…
-
Formula Error
Hi Pls can you help : ----------------------------------------------------------------------------------------------------------------------------------------------------- The formula for 'EMP02 Employee Expenses By Dept & Role'.Bonus is invalid: Bonus = IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus…
-
DCA
Hi All, I wanted to understand that on applying DCA on a line item as I am making only certain values to the end users readable. So as my that line item with DCA is getting referred in another line item for the calculation purpose. So will DCA read access in anyway hamper the calculations or will the calculations will not…
-
Descending number sequence with Dates (Months) as the heading
Assuming my heading is the time: Jan 19, Feb 19 to Dec. 20. This is due to a parameter set. and the range changes based on the parameter to be set. My line item will be Date in number. this will make Jan 20 - Dec 20 to 1, 2, 3 and so on. I have successfully sequenced Jan 20 - Dec 20. However Jan 19 to Dec 19 will have to…
-
INV01 Module - Some observations in Override Switches
Hi Anaplan team In both 'Óverride Suggested Order Amount' and 'Override Shipping Method' toggle switch scenarios, when ''checked'' the user entered values at lineitems Override Amount and Override Method correspondingly reflect in Final Shipment Amount and Final Shipping Method as per formula.Here are the steps : Initial…
-
Prior year value for selected period
Hi All, I needed a logic to pick the values as below: If my current month selected is Jan, Feb or March FY20 then populate the value from Oct , Nov and Dec FY19 respectively. Thanks & Regards Madhu
-
Formula
Hi, I have a module created with dimensions rate area, brand and channel. However, I have another module where the user inputs the values only at rate area and department level. So from the module where the user inputs the values we are getting it into the module with extra dimensions(i.e. brand and channel) thereby…
-
Formula to choose Dec value
Hi All I have one unit in my module that is missing a monthly phasing for 2 years (2022 & 2023). I have value only for December, so I want to say that if there is no input in a month, it should pick up Dec value and apply it to all months from January to November. I'd prefer to avoid saying that if it's 2022 then take Dec…
-
Forecast an amount every 'x' periods
Hi, I need to take a committed contract amount and forecast it going forward as if the contracts will be renewed for exactly the same amount once the contract expires. Contracts can be month to month, quarterly, annual, or bi-annual. The image below shows a mock-up of committed contracts in green text and how I would need…
-
Line Item Filter based on Page slector
Hi All, Can I filter my line items on a module based on my dimension page selector. Say on Total Org Level I want to view different line item and when below levels are selected I want to see different line items. Thanks Madhu
-
Cross referencing List values in module through Lookup?
Hello, I have list C_L4 costing materials containing material under multiple org- profit centers Ex: Material: 136699 Profit Center: 100050: Sales Org: 2020- C_L4 Code: 136699_100050_2020 Material: 136699 Profit Center: 200050: Sales Org: 3030- C_L4 Code: 136699_200050_3030. (Cost attributes are being calculated from…
-
Issue in fetching data from one module to another
Hey Everyone, I am facing a problem while taking datas from one module to another module. I have to Fetch data from detailed level to aggregated level. My Source File is containing more detailed data and my Target module is supposed to have the aggregated data from source. As my target and source file is containing almost…
-
Option to Tie Time Range to Current Period
In an effort to reduce sparsity and improve in every aspect of "PLANS" from the planual, having the ability to attach time ranges to the model's current period would help in so many ways. As an example, in a model set as a "Calendar Months/Quaters/Years" Calendar Type, adding time Ranges that are Current Year, Current Year…
-
lookup not working
Hi, Can anyone please explain why the below formula is not pulling any data? I wanted to fetch the details into LoS from SYS13 using LoS(numbers) as driver LoS >> Line Item List(Length of service) I tried converting the LoS(Numbers) into Text & tried vlookup again but it didn't fetch any details Thanks
-
Level 2 Sprint 3 - 'Inventory Ordering Modules'
Hi, I believe I have completed the Inventory Ordering Modules section, but I'm not 100% confident with all my formulas. Below is an example of what my outcome is when I do an override suggested order amount in week 1, along with a shipping method override. Does my outcome look correct? If you need to see the thinking…
-
Level 2 Sprint 2 DEM03 Growth Rate % line Item
Hey there, Anaplanners! I am on Level 2, Sprint 2 and am having difficulty with the Growth % line item in DEM03. Growth Rate % line item With this line item, build a formula to pull the Volume Growth Rate % from the DEM02 Volume Growth Rate by Weeks module. I understand that I need to look up the SKU to get the Parent…
-
How to sum checbox checked?
Hi All, I have maybe a simple doubt, how do it sum the checked options ? I need to have one line item showing : 3 Regards, Julio Baudino
-
Last Occurrence Type question
Hi there, I am looking to get the latest product code based on two identifiers, one is called BVFSKU and the other is Vintage: Module one is called Latest FERT - module to pull the data in to and based on the BVFSKU list Module two is called Masterdata - module containing all of the data needed and based on a list called…
-
is anaplan hosted in saudi arabia ?
hello I wanted to know if Anaplan is cloud is hosted in Saudi arabia ? and also is Anaplan integrate easily with SAP S4 Hana ERP ?
-
1
1
-
Level 2 Model builder Sprint 1- SYS05 Region Details module:
Hi, while creating this I found out that we have to use PARENT formula to reference the data. I have been trying it but no success. Can anyone help me? Thank You, Sweta
-
Fetching information from module in Anaplan
Hi All, I have a contract master module dimensioned by Contract. Each contract based on Vendor, Customer, Brand. I do not want make these 3 as dimensions as it would be a big sized module. In the target module, which is dimensioned by Customer --> the user should select Org 2, Brand details and End Date for the contract…
-
Calculation Waves
Hi Team, I'm hoping to find further information regarding Calculation Waves in regards to best model performance & best practice I have some models whereby the performance is not optimal & I think this maybe partly due to excess calculation waves. Is there any information regarding what effects waves have on performance?…
-
How to get data from source module using time range dimension
Hi, Question please. How can I get data from source module using time range dimension to target module with model calendar time dimension? Scenario: I need to get the beginning balance of FY18 from the module to be able to transfer it to the target module which calendar year starts with FY19. Please ss. SYS Time Source…