Would it be possible to implement a 'List Item' scope similar to Version Scope against line item formulae within Anaplan. My thinking here would be to allow some list items to be driven by inputs, and…
Hi team, Hopefully a straight forward one. I have 2 lists. Campaign and Show ID Multiple campaigns can have the same show however they are not within the same hierarchy. I have a module INP01:Campaign…
Hi, I have a module with a number of transactions for different entities. For all of these entities, I have a Unique ID (UID) and a valid from date. I also have a line item that uses the RANK function…
Hi everyone, I am currently building a project planning scenario analysis UX and have designs that use the line items "Month 1-18" to decide hours available by team. There is a button where we can "cr…
Anaplan's "SUBSTITUTE" formula has three arguments whereas excel's has a fourth optional argument that would allow for much simpler identification of specific substrings within a string that varies in…
This is the desired output the image below is one i got after completing inv01 inventory ordering i have error in 1. Ending inventory data for week3 and week 4 2. Shipping cost 3. Final shipping cost …
Hi Community, I have an issue where in the Page displays the correct value but as soon as I drill down it, it picks up a different value and shows a different result from that of the page. Is this an …
Hello everyone. I have successfully completed my module builder certification training. There was question during the exam that I was not able to resolve. This was related to the cell count for the ex…
the above image is in the lesson which we have to do This Thsi image The above image is what i have done after applying all formula and thus table matches the first table of first image but as soon a…
POST(PO Submitted, Shipping Time Weeks) worked in Confirmed PO Delivery Formula.OFFSET(PO Submitted, Shipping Time Weeks, 0) is right according to the hint in the module but it is giving wrong results…
Hello, I've come across a scenario that appears to be a bug when combining Line Item Subsets and List Subsets. The scenario is that I have a report module that I created a LISS of. I then created an i…
Hi Team, I have applied the conditional formatting as well as the formular but i keep getting 0 in my Forcast CF line item. Please asist to point me in the right direction of what I am missing.
Hi, I have a module with 5 products (A,B,C,D,E). all the products have some values with respect to 3 line items (X,Y,Z). Now i wanted to distribute the value of A in to the remaining products(B,C,D,E)…
Hi team, Looking for help- i have a column with number format which shows currency value ( total) which takes FX rates into account as well . e.g $2,000,000 and so on... now i want to use filters whic…
Hi friends, Hoping to get some help with a method to help me finish up a labor calculation module. I'm tasked with allocating costs to contractors differently dependent on if there are multiple contra…
I have a Module 1 with 2 dimensions. List A and List B. I have a line item in the module formatted as numbered List C which the users can select. I have a SYS module for List C. I would like to create…
Pros/cons of common approaches Common approaches: Examples Error logic User experience Example 1: Simple error messages Example 2a & 2b: Nested IF statement Example 3: Concatenation of multiple error …
I have applied right formula in Growth Rate% of DEM03 module.But the hierarchical aggregation is going on.Is it right or Can I make a change so that Hierarchical error will not take place. But when I …
I am trying to create a module with the following line items (dimensioned by products in pages and line items in rows, time does not apply). when a product is select from pages: Max slots - display ma…
I'm try to find medical cost for employee in EMP02 (Employee Expenses) drives by Role and Department where i have to reference to EMP03 (Employee Driver by Role) and SYS08 Employee details. In my form…
Hello - has any one ever successfully been able to calculate the median off of multiple dimensions? I have a list of customer spend data at the customer level and would like to calculate the median by…
Hello, I have a module with two line items. This module has product list on pages and line items on rows. 'Max Slots' has a formula that returns the MAX value of a given product from another module. F…
Yes! You can now do ad-hoc variance analysis! I'm about to jump into this right now and test it out - this is a huge addition to the reporting and ad-hoc functionality. Take a look below to hear direc…
Hello, My goal is to get the 'total volume' of product being used for certain year by different cities. Below are the two data set which have been successfully mapped into Anaplan I want to pull data …
Hi, Is there a way to map a selection made at the parent level to all the children of the parent? Product Hierarchy: L1 Program, L2 SKU My final output report is at the L2 SKU level. The users take mu…
