Hi, I have a list of projects that is in selective access. I need to be able to get the count or number of projects per user. For example user A has access to 1 project. Total count of projects is 4. …
Hi, I tried to do a filter to only display 2 lines with totals but the total lines are not showing correctly. Total should be zero. It is showing total of lines even if those lines are hidden. Can thi…
Hi all, I'm having trouble with the sum function. I have the reference module [A] as below: Then I need to sum in Module [B] that only select the "SGA" element in "P&L Total" (which is a list) but I c…
Hi, I would like to calculate the QTD and HTD in a module. It is noticed that the QUARTERTODATE() and HALFYEARTODATE() function are not working when the Quarter Totals and Half Year Totals been disabl…
I am having the below issue with a number as text. it needs to be displayed as text, for posting into another system. in the attached, in IA local I am just using TEXT(ROUND('Investor Amount (Local)' …
Hi community, In one of our models we frequently use the Mailto function. When I click the link, a new tab opens in chrome but Outlook doesn't open after. When my colleague clicks the link the Outlook…
It would be nice to have these Random number generating functions. These functions revery useful to generate some test and demo data, rather than inputting numbers and copy forward or importing from a…
I suggest a simple addition to the drill down feature that displays the summary method that was applied to the line item. This is because it is sometimes not readily apparent (especially to an end use…
How do you make a Date as a Display Name in a Numbered list? I added a formula into my list properties with the format set as Date and the formula referencing the numbered list and the Date field. It …
When a LOOKUP is done on a parent item in a module, the result does not resolve to the column with that respective parent. Subsequently the value shows 0. To reproduce: 1. Create list with leaf item a…
I have a question about parent-level commenting with line items pulled from one module to another. There are line items in module 1, which are pulled into module 2 via subset and transposed into rows.…
If my Excel model has user defined functions, ie multiline VBA functions that are called by worksheet cells, can Anaplan handle them? I could not find anything about them online thank you
Hi Experts, Please help on the below mentioned issue while adding formula for Bonus, Car, Phone costs & Medical costs to the EMP02 Module. BonusIF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonu…
Where lists are in a hierarchy, it would be really helpful if Anaplan natively understood the concept of inheritance. Here's an example. Consider two lists in a hierarchy: * L1 Countries * L2 Cities L…
Thought I would post this here as a method to calculate Forward Cover or Forward Weeks of Supply. A year ago @AnaplanIdeas posted an idea for this which is great. I'd like to expand on this idea and a…
Hi, I'm trying to create a time filter that will only ever return current month and December 2020. I've managed to create a filter for both using separate line items, struggling to combine and allow u…
I have a formula that needs to look a specific number of months back. The formula works when I type in the number of months as a hard code in the formula, but not when a use an line item containing th…
Hello, I am reviewing REP02 Size Margin Report and having issues. The Margin and Margin % are not populating. Is there a reason this would be happening. Is it not supposed to populate? I have put in t…
Hi, For a client of us we're looking into setting up a Supply Planning model where planners have the ability to plan with a telescopic view. Meaning they're able to simultaneously plan on a daily & we…
An often requested output of a trade promotions use case is to understand sales between two specific dates— be it days, weeks, or months. The solution below has one dimension in it but would work equa…
Hi Guys, I have a simple one to ask. I am loading a Period with a Text format to a Year and Month with a Number format. Example: I loaded a date of Jan 13 to a Period column. Then I need to convert it…
Hi, I am trying to create a variance Analysis for users so they can compare price & volume between to Anaplan versions (i.e Budget & Forecast, Budget & Actuals). This idea is for user to select Versio…
Would be really handy if Anaplan did either one of the following actions for import data sources: * Set the default file type as everyone or; * Permanently saves files regardless of default file type …
Hi,everyone. I would like to calculate the cumulative result of a line item. I think I should use the TIMESUM function, but I don't understand how to use it. I want to get the cumulative result from t…
I would like the ability to use a function that allows me to search for the nth time a character or string of characters occurs in a concatenated key. Currently, we import text string keys from source…
Hi team, I've got 2 simple modules with 2 dimensions, Accounts & Time. The source module has the Model Calender with Month as the Time Scale. The target Module has a Custom Time Range with Quarter Tot…
Hi All, I've been racking my brain over this one and I can't think of a good solution. I want to calculate the amount of inventory that will go expired for a given batch of materials, but as we cannot…
I want to leverage Python's statistical capabilities to manipulate data already in an Anaplan model. Has anyone done this before / had any experience with this? I know I can use Python as a data integ…
