-
Not able to apply SUM or LOOKUP
Hi, I am trying to get the Proceeds amount for each Deal in Deals list, however not sure how can i get it, Kindly advise. Here is the scenario: Target Module List : Deals, LINE item = LTD proceeds Source Module : List = Deals and Trans Type (Proceeds as one of the TT), Line Item = Amount Thank you!
-
summary method
Hi, question please. How can I sum up #transactions #1-#5 without adding the top list (alo world)? The total should only be 249 but the values is 5,772. I already edit the summary method to formula. Thank you.
-
Model Builder 2/- TRA01 Shipping Time in Weeks
Hi Been trying to figure out this formula but unable to due to the Year to week Lookup criteria . Any suggestions pls The formula for 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' is invalid: 'Shipping Time (Weeks)' = YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)' [LOOKUP: 'SYS01 Time Settings By…
-
Days in Month
Hello Everyone, New model builder here. I'm trying to figure out how to display the amount of calendar days in month. I used DAYS() but it's coming back as 28 days 28 days 35 days which I presume is because we are in the 4-4-5 timescale. Is there a formula that I can use to figure out the days for a current period? In…
-
Comparing List Items
Hello All, I'm attempting to do expiration calculation on lot codes based on a few points QTY in the lot Sell by Date Days on Hand When importing the inventory, we add 1,2,3 etc... to each line and use that as the code for the list. So we import the codes into the list first, then in the module it would look something like…
-
Data import of different Dimension
I apologise for asking a basic question. As I have none to assist, so seeking assistance from Anaplan Community. The Source Data Module has Yearly Values. The Target Data Module will copy all the values in Weekly as well as Monthly. Please assist me, if any Document is there in Anapedia, mentioning the way out.…
-
Formula for Number or text
Hi, Is it possible to format a line item so users either input a number % or "n/a"? Thanks
-
Pivot conditional formatting multiple levels - format selected columns
Hi Can anyone advise if it is possible to give conditional formatting only to the 1 of my column levels if there are multiple levels? I have the following columns: Level 1: account (sales and ebit) Level 2: scenario (act, bud, forecast, and variance to bud and forects It seems i can only filter based on account, so it…
-
Anaplan usefulness over others
Hi Friends, We can perform What if analysis in Tableau. So can't we directly import data from SAP and perform better data visualization there? Tableau also can do Budgeting & Forecasting. Why do we need Anaplan in between?
-
L2 Supply Chain Model DEM01 & DEM02
Looking for an opinion Is it best practice(DISCO) to have the following in a single module or is it preferred to have it in separate modules DEM01 & DEM02: Line 1 : Growth % by Month ( time set to month) Line 2: Growth % by Week ( time set to week) Thanks
-
Ranking across a dimension consisting of multiple list items
Hello, I'm trying to create a sort of 'heat map' based on percentages within columns in a table. Basically, what I'm trying to do is transform this table into something where each column would be separate from the other in terms of conditional formatting. For example, 'training period' would have 'problems with…
-
Formula - Yes, no, n/a
Hi, How do I build a formula which states if a = b, then "not required", if a > b, then "yes", and if a < b, then "no". Thanks in advance
-
Level 2 Model Building/ 2.4.7 Activity
Hi, Having a hard time figuring out how to write a formula for Line Item forecast cf in Module DEM03 Demand Forecast. The instructions are below. Write a formula for the line item: * If Initial Demand Forecast is EQUAL to the Final Forecast, set value of Forecast cf to 0. * If Initial Demand Forecast is NOT EQUAL to the…
-
FX Conversion Help
Hi, I currently have a list of bank accounts in various currencies. I need to convert these currencies into the product currency. I am currently converting all bank balances into GBP using a FX module and then converting all back to the product currency. However, is there another way to do this? The excel file I'm trying…
-
New Best Practices article: The Importance of Building and Maintaining a Clean Model
All, Just wanted to share a new Best Practices article on The Importance of Building and Maintaining a Clean Model and please make sure you download the attachment where it answers frequently asked questions and what to look for. Link Thanks, Rob
-
Driver-based planning, connected to Finance app
Hey Anaplanners, I'm curious about best-practice for building connected, driver-based models. I have a an idea of how I'd do it, but not sure how others would accomplish the same objective. So, I'll present a very simple example to get the point across, with the objective of receiving feedback on how to correct / improve…
-
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…