Most of the modelers know what is wrong with their formula, the moment they press enter and it starts toating system. There should be an option to **** the error processing in case of formula errors.
Hi Anaplanners Has anyone built an Excel Search function equivalent in Anaplan? What I would like to replicate is: 1. Client has a text mapping table (screenshot 1) which maps Strings in Column B to t…
Hi All, I would like to take a count of the users using the list Users for every month. I have a module with: Row: Users List Column: Time(Month) Line item : Number(whose formula is 1) I need to sum t…
Hi All, What are best practices / tips to ramp up to an Anaplan ecosystem. I received my Model builder certificate and have a good grasp of the system terminology. I recently was brought on in the mid…
Hi, I'm trying to find a way to pull for the previous day, while skipping over weekends and holiday's, for the same LI. Below is an example of the formula I'm trying to do, but I get a circular refere…
Hi Everyone, I was wondering if it was possible to have the box to select a subset for list to be shown in the UX? For example I have 2 subsets, CAPEX, and EPMO, among the project request list (where …
Hi Community, Below is the screenshot of the column Revenue Actual CY. As you can see the Net Operating Expense (income) line has a value of 285,480,176. It is the sum of Corp Service Income until Qua…
Hello All, I was wondering if there is a way we can use FINDITEM to find a value from multiple columns. The way FINDITEM works is by comparing a list with a specific line item (column). However, in th…
What is it? This article explains how to SUM, SUMIF, and use other aggregation methods using a dummy list rather than Anaplan’s native summary functionality. Why is it useful? Anaplan's native summary…
When a user uses the drilldown feature it would be awesome if the platform highlighted the particular logic string that was being applied within the formula to determine the final result. This would b…
Hi, I need to get data from a line item from one module with a different dimension with my target module, I cannot do a lookup because the 2 dimensions are not totally related. See details below ; I n…
Hi, I have a grid in which there are multiple line items (approx. 25). These line items are user inputs and when the user enters these either manually or through file upload, he sees a validation mess…
In Excel we have Goal Seek function to set Target value of a calculated cell and based on that target value, excel performs reverse calculations and gives source value needed to achieve the target. No…
Hello, is it possible to have a formula that is formulated for a certain version or from an IF, but then allows you to hard code if that is not true? For example if we were to say "IF ISACTUALVERSION(…
As per instructions, UX page for stock exception review, time period are monthly , half yearly and yearly. Where my time drop down shows the weeks too. Is it not managed well till now? Regards
Hi Community, I would like to ask advice on formula revision of my clients report. Below is the target module. The column of last year is where we are encountering a problem. Requirement: it is suppos…
A quick suggestion please , we have created a INV01 Inventory Ordering module and chart for UX as well but my quick feeling is none of them matches with view in terms of line items and sequencing of …
I'm trying to forecast the details by department's with their vendors, like for example Anaplan as a license vendor I want to forecast by that line of expense as part of the Technology department that…
Hi, It shows just zero in Shipping Time Weeks line of my INV01 Modules although the formula is correct. On the other hand, TRA01 Shipping Metrics by Week do not have data yet. I don't know where I am …
Hi, Need help creating a formula that will look at LI for a rolling 5 day forecast and return back the max number of those 5 days. I set up a systems module that looks at the forecast for 5 days, and …
I have to replace CRLF (carriage return / line feed) characteres form a text line item. How can I use the FIND function or more better the SUBSTITUE function to replace such a CRLF char. Result = SUBS…
I am working on L1 Model Building training and I am on exercise 6.8.6. It says "In your model, open the SYS04 Location Details System module in Blueprint view. Add the formulas to the line items:" Lin…
I am stuck - I have a Boolean that I want to populate based off the value in a given list. If this was excel I would write the formula as If Pay type = H then True else false. But I know that I can't …
Hello, I am not understanding why I don't have a date showing in the current period start row and why I don't have a check in the actual period row as well but in the forecast period and forecast mont…
I have a driver called "set to plan" which is just assigning the planned amounts to the forecast periods, but this is only happening for 2022 forecast periods. The previous driver Calc: IF Driver Meth…
Hi, I am having trouble getting the Total Beginning Inventory to map correctly. I am using the formula: 'INV01 Inventory Ordering'.Beginning Inventory [SUM: 'SYS08 SKU Details'.Supplied By]. I get the…
I need to sum values inputed in months into a line item independent from time over a specific time period already determined by start and end date how can i do that please ???
