
Calculation Functions
Calculation Functions
Discussion List
- I would like to submit an enhancement request for the LAG function to be used between time ranges that are not the same but have valid overlap. The constraint that disallows the use of LAG between any…
- I spend the last 2 days trying to dynamically linked a specific date (specified by a user) I created a module to have visible the versions, country and initiatives (as my lists) and of course the line…
- It would be really helpful to me when building complex formulas if I could build it up in pieces without creating lots of line items to do so. Ideally I could build it in pieces without getting plague…
- Got the idea I'm trying from here: https://community.anaplan.com/t5/Anaplan-Discussions/Lookup-on-Parent-elements/m-p/1478#M2397. But, we needed to change it up a bit as I need it to be user specific …
- Here is my problem, I have two different modules without timescale or dimension. One module has quantity and dates. Second module has start date and end date and I would like to sumif within the range…
- Hi, Please see details in the attachment. Regards,
- Hi, I'm trying to load master data in the system but in the files which I trying to load have erroneous records like one child has multiple parents. So is there any work around in which I can identify…
- This seems to be a reoccurring topic. I also am only returning an answer of 0. My equation is Region Percent * Geo Goal Set.Projected Goal[LOOKUP: Parent]. I have also ensured my Forecast version is c…
- I have a master warehouse budget model which has several modules but let's consider the following modules for example: Shipments, Freight Charges, Headcount, Inventory etc. All are inter-linked by for…
- Hi Experts, I have a requirement and i am confusing how to resolve this. First Module Row Axis:Product Column Axis:Line Items Second Module Row Axis:Flat Product Column Axis:Line Items Both Product an…
- Contact centres regularly use expensive workforce management solutions that are inflexible and difficult to work with. These solutions focus on managing call handler schedules (ie what they're doing a…
- Hi @DavidSmith , I had one more query . For instance, A module consists of 6 line items, Is it possible to importing the data into module for each line item separately( as of new set of data into each…
- Hi All, how to get the values form one module to another module in list items using subtracting function. Please find the attached Screenshots list items formula given bellow: Base-Base Base- Simulati…
- Hi, How to select the yearly average value of a line item from a module that is dimensioned by time (monthly), for the current year, in another module that is not dimensioned by time? Please note, I w…
- Hi, How to select the yearly average value of a line item from a module that is dimensioned by time (monthly), for the current year, in another module that is not dimensioned by time? Please note, I w…
- If I am using dynamic cell access to some line items by using write access drivers and read access drivers then quaterly data not displaying, If I am removing it , then it is like usually displaying n…
- The CUMULATE function when used against a list, currently accumulates in the original list order even when the list has been reordered. Anapedia states this is how the function is meant to work, but I…
- Hi, I have this module of list Quota Types and I want to find the items Quota Types list and display them in Secondary of Secondary Quota Name line item below, who has a parent of Secondary Quota Name…
- Hello, Is there a way to reset the number generated in a numbered list? Also, is there a way that we can sort a list in alphabetical order after import? Thank you!
- This is a platform to share ideas about improving Anaplan platform. But there is something I would like from your side a bounty program, for finding bugs in the platform. Just a suggestion to improve…
- I have the problem .. i have a list on left and i have the formula like the picture .. half the list using formula and half again using formula but null value . how work for the problem?
- Hi, I'm working on the UX section of the introduction to modeling, and I cannot get the headcount module to populate with data when it's on the dashboard. Interestingly, there's data in the module its…
- Hi, I am trying to import a product list which is a numbered list form another model say ICM. But while trying to import it,it shows the invalid parent entry.However the list is getting rolledup to th…
- * I want to ask about List. i want to take code on Account L0 Flat List to Account L0 . Account L0 FLat is list format .. *
- Hi all, I have a list named "TAT Hours" and a line item "TOTAL HOURS" that is in number format. I used FINDITEM formula to get the number of hours (TAT Hours) in the list, here is the formula: FINDITE…
- Is there a workaround for selecting a non-number line item in a Line item Subset? I've created a filter for increasing and decreasing the number of lines shown in a dashboard table using David Smith's…
- I have a module that needs to tell me whether a customer is present in more than one country in each region. For example, Customer A is only present in United States under AM region. This means that i…
- Why is ramp format a number and not percentage?Am trying to appreciate the formula and output on this line item.
- i'm using three versions in my module, here Actual, Forecast, Budget. i have the actual and budget data available and they can be manual entry data. Forecast data should be formula given. Actual Budge…
- i have a question, on my project i have many versions such as Actual, Budget, and Forecast(Jan-Dec) . on Actual and Budget version will input by user but for Forecast this will retrieve data from anot…