Hi - hoping to see if anyone has a solution to this: In the following example, I'm trying to calculate (going backwards) when the sum (less current period) would be greater than the test doh line item…
Season's greetings all. I don't know why I am wrestling with this formula as it seems straight forward but it does not appear to be working correctly. My line item formula is as follows; 'INV01 Invent…
Season's greetings all. I am completely at a loss. My final confirm PO equation, after several iteration, is as follows; IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Ti…
Hi, I need your help. I have 3 lists: Product, rate, invoice and two modules: I want to put in invoices.valid rate the max number# of rate list where all following conditions are satisfied: * Rates.st…
If you are using a multi level composite hierarchy as your main reporting list (as you should vs ragged), you have encountered the need to filter it and display many levels of it in many different das…
Hello, I am section 5.5 in L3 Sprint 2, where we are asked to - "In the Data Hub model, create an Employee Details system module. Then, download the Employee Details data file and import into the Data…
Hi, I am trying to workout a formula for Forecast Version Line Item. The requirement will be as given below. Source Module: Source Line Item - Sum of "Sales" of last 12 months in Actual Version Target…
Hi, I have a date formatted line item (example: 4/1/2020) - this is in mm/dd/yyyy format However, i want to show as 1 April 2020 or 1 Apr 2020. How do I do that?
Hi, Question please. I am trying to use a system filter in my report module so that I can see first the start date of the project after the All Periods (sum). The filter is working, however, when I p…
Hi, Trying to create a Line Item in my SYS Time Setting Module that filters out all of the Business Holidays that we are not operating. This is a Daily Model and not sure how to approach writing the F…
As a parting gift, check out these 3 latest videos showing how to model: * Time in a flexible way * Different sign conventions * Alternative Hierarchies https://community.anaplan.com/t5/Best-Practices…
Hi Community, We have Ragged Hierarchy where list members are more than 60 characters each having different codes but have similar names. If we go for numbered list we cant add display name property f…
Hi all, My formula works well in my module, but it cannot go through the exam. I just want to know where I get wrong here because I was very confident with my formula. Below is what I have, please adv…
Hi, Not Understanding how to choose which Context Selectors levels are needed for certain List. It is on the Exam and I have watch the recommended videos and just need more explanation. Thank you
Hi, I got a collect with sum problem. Source module (Before creating the line item for Collect): Dimensions: Time, Department Line item: Cost1, Cost2 (Number format) Target module: Dimensions: Time, D…
Hi, question please. I am doing a test variance module between line items of IC Run, Actual and Forecast using LIS, Versions and Project as my dimensions. I need to get the value of IC run, however, t…
My beloved Anaplan community"How lucky I am to have had something so special that makes saying goodbye so hard” I can't take credit for that quote - I have to thank AA Milne for summing up how I am fe…
Hi, I am having issues using the optimizer for production allocation. The model is for capacity planning. Problem statement Need to allocate the SKU demand to compatible factory lines based on the fol…
Hi Community! I am currently exploring the best way to identify unique text and count the unique text matches across 9 text line items by one line item that counts based on unique names: It would poss…
Hi all I'm currently working on a large P&L module with a lot of line items (100+) that are either populated via a lookup to calculations modules or calculated by taking a YTD average + inflation. The…