-
AGENTS vs. AGENTSB
I am looking for some more background on the differences between these two functions. I understand that AGENTS takes into account the SLA and target response time, but where my confusion lies is moreso with AGENTSB. Agnostic to target response time, how does AGENTSB calculate # of servers based on a 'busy period'? What…
-
Count items in a flat list?
Hello, I am trying to count how many items are in a list and display it in a module? In the example below we have 3 items in the list. Does a function like this exist?
-
Data Entry Shortcuts for data input in UX
It would be useful to have more shortcuts when entering data in the UX. At the moment we can enter e. g. 1e3 to input 1000 in a cell which is great and makes it easier to enter high values. In addition, I would find it useful to have at least these shortcuts as well: Shortcut ‘+’: By entering a value using '+' the value…
-
Ability to record timestamp of input as a separate line item
It would be extremely helpful from an end-user and a workflow perspective to have the ability to capture the timestamp of a manual input as a separate line item, instead of having to look through model/cell history manually. That way you could easily see when the latest input was entered.
-
Retrieving last non zero value for daily exchange rates
Hi, I have a daily exchange rate module which store the daily rates for multiple currencies. I wanted to get the last non-zero value for each date for example we have daily exchange rates for 1 Jan 2021 but none for 2nd and 3rd of Jan 2021, so the daily exchange rates for 3 Jan 2021 should display the rates of 1 Jan 2021…
-
From Native Versions to Fake Version List?
Hi All, As it is not possible to SUM down native versions is there a simple mechanism to take data out of versions and restate it within a fake version list? I know this is achievable via a series of nested IF THEN ELSE queries but this approach is not sustainable as it needs to be updated every time a new native version…
-
PREVIOUS FUNCTION, summary issues
Hi all, I am having an issue using the PREVIOUS function. In this project I have a timeline split in quarters, semesters and years, thus I should be able to see the values from the previous quarter, semsester and year in the line item called "Previous period". It seems to be working for the quarterly values while it fails…
-
Uses for TEXTLIST
Hi All, I am unsure where I might use TEXTLIST function. There has never been a need for me to use this but I would like to understand where, when and how this might be useful. Your insights are much appreciated!!
-
A doubt in functionality of "ALL" function
Hii Community, Here, Source module contains Employees Dimension, Department and Country as List formatted Line Items and Bonus as Boolean format Line Item as shown below. Target module contains Country as Dimension and Employees with Bonus as a Boolean formatted Line Item as shown below. When I am using "ALL" Function here…
-
Additional modes for Formula Scope
Whilst the current method for formula scope encompasses the existing options (Actual, All Versions, All Versions Except Actual and Current), there is sometimes a need for formula scope to be applicable to specific versions outside of this scope - For instance, side loading of a budget. Whilst Add Version Formula covers…
-
Level 2 Model Building Conclusion - DEM04 Demand Export Demand values
Hi, Could someone please help me with the following? Solution DEM04 should be this: My DEM04 Demand Export: My values are way higher, Demand line item is not for each product SKU. How can I fix this? My DEM04 blueprintview: Baseline Forecast: Thanks in advance!
-
Shipping time weeks
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] After applying this i am not getting data populated in shipping time week line item
-
Copy data from one month of Current Year to all the months of Future Year
Hi , i would like to copy the data from sept 2020 to jan2021 -dec,2021 for Budget version and take May,2021 data and copy to Jun,2021 -Dec, 2021 for forecast version. Any suggestions to achieve this.Sept 2020 Jan 2021.....March 2021....Dec 2021 20 -- 20 20 20 Thanks Sri Nitya
-
How can I get PY Sales Revenue from Sales Revenue in a module without a time dimension?
I have a module without time dimension but there is a column with the sales revenue date. My formula for PY_ar date is just the ar_date minus 365. Can I leverage these two to get PY Sales revenue for a particular territory? I tried the following and got errors: Sales_Revenue[lookup: territory_id, lookup: PY ar_date] Sales…
-
Community perspective: Time Settings impact on PERIOD function
When changing the model calendar or available time ranges beware of the unintended consequence on any PERIOD functions in your model. Here are the details on what caused a phantom issue at a customer and how we solved it. Problem While working with a customer to reduce model size we took a hard look at how they were using…
-
How to traverse hierarchies: The power of loops
Introduction Whenever you use a hierarchy, there will often be times when you are required to seek specific information which will necessitate some way to traverse the nodes and map out their connections. What you seek may be a list entity, a specific value, or a unique identifier, and this can become complicated if the…
-
Commission calculation
Hi, Can anyone tell me whether the below calculation is correct or not? If yes, then can someone please clarify why the quarterly balances are different Thanks AB
-
Filter inquiry
hi Community, I just got this requirement recently and it is giving me quite a challenge. the requirement is to select the current month then display the 3 prior months and Current month on the table. So example, user will select Jan 23 then the table should display Jan 23 Dec 22 Nov 22 and Oct 22. so far this is what I…
-
How to vary the calculation used for each version for a single line item?
I have a large model that is used to generate a business forecast. Each time we need to generate a new forecast or scenario, a new version is added so that the inputs can be changed and the outputs then compared to previous versions. However, sometimes the calculations themselves need to change to reflect our evolving…
-
Rank Formula Work Around
Hi! I have a module dimensionalized by a list of unique identifiers that is the child of a Location list. I'm trying to rank survey dates (a date formatted line item) in descending order based off of how recent they are BUT there are multiple UID's with the same survey date. The problem is, with the "RANK" formula, the…
-
Hold and Release functionality
It would be great to have "Hold and Release" functionality extended to NUX as well. Break back seems to be working fine with NUX but sad to see missing hold and release functionality. Hope this feature will be added soon. Thanks, Sandeep
-
Convert Month to Number or Text
If we use the the MONTH function to convert a month - for example "Jan 15" which is month formatted to Number, the outcome is "1" and not "01" My requirement is to turn "Jan 15" as 201501. So I wanted to convert Jan to 01 instead of 1 and after that I can concatenate to get the result. What would be the way to convert Jan…
-
Plain Text Type or CLEANTEXT function
Anaplan allows users to paste text from dirty sources like Word which includes nasty characters like CR/LR, smart quotes, em/en dashes, etc. These invariably cause problems when exporting data from Anaplan. I suggest adding a fourth Text Type to the Text format. Plain Text would convert entered/pasted text to plain text…
-
Lag Function without Time Demensions
Hi Anaplanners, I am trying to model a queue building up in Anaplan and I am wondering if there is any way I can use the Lag function to return the adjacent value without time dimensions. The principle is to add the queue from the previous segment and add to the current segment, however the model does not have any time…
-
Quarterly Account Sales Revenue Targets
Hello, I'm in the process of building the module for user story 1.11 and I am struggling to get the correct formula. I need to convert yearly data to quarterly data using the SYS99 Time Settings module (only line item dimension). My formula currently pulls the yearly total for each quarter which is incorrect. Any guidance…
-
Quarterly Account Sales Revenue Targets
Hi @JaredDolich @Misbah , How are you? I completed the User Story 1.11. But I have a question. When I select All Account, the % of Account Sales Target aggregate automatically. Any help would be appreciated. I am looking forward to hearing from you soon. Best regards. Wei
-
Level 1 Model Building Exam - Activity 6
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from SYS08: I keep getting the wrong number whether I use EMP02 or EMP03 in the formula.…
-
Turn off suggested list/line item names in new modeling experiance
Is there any way to turn off this feature? I often just want add a simple correction to a formula, hit enter and move on. Instead of just the minor edit when I hit enter to close the formula editing it grabs the first suggested line item or list name. For example I just need to add an apostrophe and want be able to just…
-
How to Find Combination of List
I want to Find combination of List. I have relationship of Customer-Product and Product-Supplier. Then I want to find combination of Customer-Supplier. Now I don't want to make Lineitem which has "Customer*Product*Supplier" as Applies To because of memories. What kind of formula should I set?
-
Formula Help (Condition Statement)
Hi, I need help on creating a condition where if one LI is lesser than another LI, then my intra-month growth amount must be less than my write off amount. Not sure how I can make this condition happen in Anaplan. Please advise. Thank you