-
Dynamic List
Hi, Is their any way a list automatically change its hierarchy or parent (Active to Inactive) if it meets a certain criteria? Thank you!
-
Time Range Messing up Time Boolean
Hi, I was testing Time Range to calculate items for the current year only. I created an FY20 time range However, as soon as I use the Time Range in one of the modules, a line item in another module starts acting weird However, as soon as I delete the time range (by first removing the references), the formula starts working…
-
Designating Sales Reps to Accounts Process Questions
Hi, What is a sales quota matrix? What are different input parameters and what is output? Thanks, Sourabh Kulkarni
-
Urgent!! How to get previous month when production happened?
I have a product list, Month dimension and i can see monthly Production datas in the module . I want to get the Last month when production happened for all the products (let's take one product as example - where production happened on Dec-19, Jan-20 but no production in Feb now when i see the line item Last month of…
-
Advice how to structure rolling forecast formula with time element
Hey- I am looking to build on a formula in my rolling forecast. I am having trouble laying out the necessary steps. Percentage Seasonality: Each period in a year (12) has an assigned rate. When I roll my forecast, I need the percentage to take the current forecast month rate / the sum of the remaining forecast periods'…
-
how to identify text
I have two line item, remarks And rem, remarks is Text from data uploaded and then I want to on line item "Rem" just identify "Commission" and "Rebooking and Refund", but the problem is the words in front of it always change, I can't hardcode with mid, or right. how to fix it? any solution. thanks before
-
IF list item 'x' THEN 'do this' ELSE...
I am trying to do an IF statement within a module dimensionalised by a List ('Volumes') which has 2 members: Retails and Wholesales. I need to do a particular calculation depending on if the 'Volumes' are Retails or Wholesales. I have tried IF Volumes.Retails THEN x ELSE y but this not work, giving the following error…
-
YOY-Growth% Calculation
Hi, I would like to calculate the YOY-growth % between year to year but it seem I fail to calculate the number even I bring the Previous Value also. Thanks, Kiwi
-
Another work around method
Hi, I would like to ask if there are any other work around for the attached issue. Please see attached document for details. I was able to get the desired result using the IF function but I want to know whether there is another approach to it. Regards,
-
Define Multi Dimensional Level Payout grid
I have a scenario where i have to calculate the commission based on multi level payout grid. Input : End user will be able to define payout grid at any level of dimension by month on month , based on that particular month payout structure. Ex : April month Applicability of Payout at 2 level of list i.e A,B. Assuming Each…
-
SUM vs LOOKUP - Visual Representation
For those like me who like visual aids, I put together a diagram of when to use sum vs lookup in a formula. Hope this helps if you are struggling when to use each.
-
Saved views reference
Hi Anaplaners, Is there a way to know if and where a saved view is used? in case I want to delete it. It's easy to determine if a module or a line item is referenced and where. Anything like that for saved views? Thank you -Einas
-
How to keep current time scale data intact while moving to next Current period
Hi, Just for my understanding, What I need to do in Anaplan so that when I change my current period (Q1) to next quarter (timescale Q2), my current quarter (Q1) data didn't not get delete and automatically covert to hard coded figures. Thank you!
-
Multiple lists as only dimensions and LOOKUP
Hi, I wish to lookup each and every individual cell in a module that is dimensioned by 2 lists. No time dimension. I have a Module "Sequencing" dimensioned by 2 lists - MonthNames and Offset. Attached are screenshots of the two lists and the module. The module has one line item - a % number that determines for each month…
-
Using subsets as conditions in the formula of list properties
Hi , I need help on the subject . I would like to give a conditional formula for one of my list properties based on the list subset involved. Please let me know if this possible , if yes, how ? Also if not, please suggest alternatives. Thanks in advance! -Aishwarya
-
Parent / Child - Formula
Hi Community, We're stuck on a formula and not sure if it is remotely possible in the first place. Can a Boolean be TRUE for the Parent but FALSE for all the children? To give some background: In a Planning model on Dynamic Time (lists, not native time) we have Week - Day hierarchy. On the dashboard there's a 52 Weeks…
-
Update Master data based on approved values
Hi Can I know how to update existing master data with approved values at end of approval cycle without overriding the existing data set ? Thanks Tejaswini
-
How to maintain same order of "Reselect Items to Show" between multiple environment
Hi Expert, Please provide me with some advice and help my model building. The situation is.... 1. In Development environment, Production Data List (Custom Week, such as 2021 W01) as dimension is selected and rearranged by "Reselect Items to Show" on a dashboard. 2. This setting is imported to Production environment via…
-
Circular References - OFFSET
Hi, I want to create something like the below example, but Anaplan returns circular references. Could you please give me an idea? Example In the above example, I input below formulas Last month stock = PREVIOUS(Stock) Consumption = get from different module Planned Received Amount = OFFSET(Recommended Order Quantity, -1,…
-
Level 1 MB Lookup function issue
Dear, I am trying to apply a lookup formula to retrieve data but I always get an error message that is not mentioning what is the error. I think my data should be ok, as well as the formula I entered but still I get error messages. I attached the input of my formula and the error message i get. Many thanks in advance! kr,…
-
Picking up opening balance
Hi there I have two modules. Module A has by week time scale and module B has by month time scale. If module B want to pick up opening balance from module A, what formula should I use? PS, has set up the "The first week?" logic but don't know how to pick up the value from module A. Thank you.
-
List items maximun
What is the maximum list items, can I add in a list?
-
Summary setting for module dimensionalized by years and fake months list
Hello, I have a module dimensionalized by years and a "fake" month list (and other dimensions) so I can see line items month to month, year over year. I'm pulling the data from another reporting module that's dimensionalized by time (month) so I'm using a line item to map months to years and using that as a lookup. This…
-
How to hide summary item in dropdown list?
Hi Experts, I'd like to ask how to hide the category summary in lists. The screenshot is what I'm developing now. In this module, client set parent and child product for set selling. In this dropdown list, is it possible to hide parent category here?
-
Formula for Summary
I have a case, i want Monthly Amortization Line item can show Quater amount. but not show because on Summary have Sum,Time:Formula. Can give me a answer. Thank you. Help me
-
Level-2 Certificate
I have completed the conclusion exam of Level-2 and uploaded the model history also. Past 24
-
Active Child list members under a parent
Hi - Say I have a hierarchy with two levels: L1 and L2, L1 being the parent. Not all L2 members are at a point of time active under L1. So, we have a module that specifies which L2 member is active in a month (identified by a boolean). For disaggregating the data from L2 to L1, I need to ensure the volume is disaggregated…
-
Find formula
Hi Friends, Do we have any special formulas for the below calculation.
-
Filtering line items or lists by another list
I have a module of multiple different input line items, but those inputs vary by the elements in a list. For example the North region (list item) has 2 of the 5 inputs, and the south region may have all of the inputs. I want to be able to use a filter to only show those applicable input line items for its respective list…
-
Level 1 Model Building
Hi Team, On the 'Introduction to User Experience' slide, I am not seeing the 'Next' button getting enabled even after selecting 4 differences for 'Model Builder' and 'End User' views. And hence not able to progress in the course. Has anyone faced this issue? Thank you Gaurav