-
Date Input is outside the model time range
Hi, I have a date formulas calculation to test whether the line item is falling within certain year, however cannot figure out what to do for the lines that fall outside of the model time period set up. For example, I have a contract that starts from 2020 to 2025 and the model is set up as 2 past year and 2 future year (so…
-
Reverse Cumulate Alternative?
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. In Jan 20, it would look back 3 periods to be greater than or equal to 92. (Oct/Nov/Dec) In Mar 20, it would look back 4…
-
get item numbered list depending on a range of dates
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.status = true * Invoice.Prod name = rates.prod name * Rates.start date < Invoice.Invoice date < rates.end date Can you help…
-
Last 12 months SUM and Actual Version
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 Module: Target Line Item- "Sales" for 1 period in Forecast Version. Eg. Assuming I am forecasting Sales in Feb 2021; So the…
-
Level 2 Sprint 3 Confirm PO
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 Time Weeks)ELSE 0 Is there a logic context error here somewhere that I am overlooking? Any help would be greatly appreciated.…
-
Filter/Sort
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 put the All periods on the left side column the filter will not work. I need to show in my dashboard the columns, first the…
-
Modelling Best Practices
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/Modeling-Best-Practices-Video-Series-1-Flexible-Time-Mapping/tac-p/93477…
-
Sales Incentives and Timescales
I am in the process of planning out a build for our Sales Incentives Calculation and I am wondering the best way to deal with the timescales. The data that we get on the Sales performance is based on a Performance Period (Month or Quarter) which enables us to work out the percentage payable for the scheme (There are a…
-
Overwrite calculated line items
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 problem is that some of those average YTD values turn out to be negative due to a one-off negative transaction in the…
-
Hide past months dropdown
Hi, I have created a module where the user can input costs manually based on a line item formatted by Time Period (Month). They are now asking if I can hide the past months as they go forward to always only show future months. What would be the most convenient way to go about that? I understand that I could create a list…
-
Parent names for a numbered list in ragged hierarchy
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 for parents and if we go for normal list then duplicates are there and list members are also having more than 60 characters.…
-
REP05 Formula
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 advise. Thank you! Solved! thank you all
-
Conditional formatting on LISS based on Collect() line item value
Hi, I have a financial reporting module with only one line item, Collect, which as the name suggests is collecting values from a LISS with the Collect() function. The LISS is a fake versions list that has actual, budget and actual vs. budget as list members. I now want to do conditional formatting to the "Actual vs.…
-
In module to check if user have selective access on the list members
Hi Team, I need to create a module in which I have a Boolean line item and applied lists are User list and a list in which I have given selective access to users. I need to mark the line item true if the user have access(read or write) on the list item else false in the module. Could you please suggest any solution for…
-
micro lessons -how to enlarge print where you are able to see...print is too small
There's no way you can see micro lessons charts...help!
-
why can't we search or filter for models in the App area anymore? Looking for a Docusign demo model.
why can't we search or filter for models in the App area anymore? Looking for a Docusign demo model.
-
Collect with Sum - An Error has occured on the server
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, Department, Charter of Accounts Line item: Cost (Number format) In order to get the costs from the source module I've created…
-
How to get the value from the source without time dimension
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, the module does not have time dimension in compare with my module data for the actuals and latest budget (forecast). I used…
-
rounding up in Anaplan
How do I make a Line Item round up its numbers in Anaplan? Thank you
-
Best way to identify unique text across 9 repeating text line items across and count
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 possible with a monster of a formula using multiple IFs but this not necessarily best practice. For example if I have line…
-
quarterly snapshot
numbers will be uploaded quarterly but in YTD figure, I need to plot the quarterly numbers. Q1 YTD will be imported in Q1 and I need to save it in my Q1 column Q2 YTD will be imported in Q2 containing both Q1 and Q2 numbers, I need to retain the Q1 above and get the number/result for Q2. By this time, columns for Q1 and Q2…
-
How to pick up my previous day not including weekends
Hi, I would like to some advice on how I can pick up my previous day not including weekends. Ex) My previous day for Monday would be Friday. This is the Formula I tried to use below. I have a Time Filter Line Item that marks 0 for any weekday and 1 and 2 for weekends, so I can try and only pick up the 0's. Below is my…
-
Building Question
Hi, I'm trying to make a unction that takes my ending balance at the end of the month and moves it to another line item. This is what I tried but totally did not work, need some advice. Thank you 'S01 Time Filter'.End of the Month[select:'Securitization Master Acct (x5000 Closing)']
-
Time Setting Weeks
Hi, How can I limit the weeks to fall to its month only? In my screenshot, my Wk35 Aug 30 falls to the month of September. Regards, Tom
-
Assign Action
What Happen with code of child list when we assign list item to Parent using assign action?
-
Past model building sessions
Where can I find the recorded past session?
-
Splitting of list elements from list into line items
Facing Issue Content Description We are facing a difficulty in splitting months from the list drop down in New Period(Quarter) into its corresponding M1, M2 …..M5 line items. STEP 1: We are selecting the length of the period from New Period(Quarter) line item say 3 months. STEP 2: After selecting the New Period(Quarter)…
-
Anaplan Live! is this week! Join us December 9, 2020 for this LIVE event.
Boost Your Model Building Expertise Through Interactive Sessions At Anaplan Live! Register now! Designed with model builders, end users, and even new learners in mind, the event lets attendees interact in real-time with presenters and fellow Anaplanners. Join us on December 9 from 10:00 a.m. to 1:30 p.m. CST. What's on the…
-
Formula for next month amount
I'm trying to write a formula for picking up a amount in the Next month. Below is the formula I'm trying, but not working. Line Item[Lookup:Next()] Want to look up the amount in that Line Item for the Next month. This formula is not working. Thank you
-
Level 1 Model Exam Activity 5
In Activity 5 of the model building exam, it asks to adjust formulas for EMP02 Employee Expenses module for the Bonus, Car Costs, and medical expenses to reference driver data in EMP03 Employee Drivers by Role module. I have no idea what that means, can you help me?