Ok, here's the situation: - I have a transaction module - The transactions are children of Cost Centers - The transactions feed into a reporting module using a SUM function - There are certain "specia…
Syntax YEARVALUE(x) where: * x: Source line item or property to be summarized. Format Input Format Output Format x: Number Number As from above we can see input & output format should be number for YE…
OK, I've already gotten one question answered around this. Just to recap, I'm creating an alert monitoring system that will flag when a stock goes low stock or out of stock. I have a BOOLEAN for when …
Hi there I wish to populate the line item "FY TEST" with the future financial year when any "Dec" month is selected in line item "End Period (Last Actual)" For example, return "FY20" in "FY TEST" when…
Hi, I have a module with time range(quarter) as dimension and also I have time range quarter as a List: I want to populate as true(boolean parameter) for all the fields i.e >= List time range as below…
Hello Everyone, I've setup a weekly scenario tool that shows your starting and ending weekly inventory with the line items being the key factors like Forecast, Sales Orders, Purchase Orders, Planned O…
Hi We currently have an asset forecast module set up that calculates the NBV of assets over time which currently only uses straight line depreciation so it's reducing by the same value per month...sim…
Hi all, I would be really interested to hear your thoughts on the Cumulate function and how you have best utilised this without affecting performance? I understand on longer time ranges it is usually,…
I'm curious what others' thoughts are, or if there's been any testing done regarding the performance difference between nested IFs vs. OR/AND. I found a very old thread on this topic from 2014, but I …
Hi, I'm wondering if there's a way of breaking data down from a top-level? The data file that I get is an import that comes in at level 2 in my hierarchy. I need to then take this data and show it app…
Hi All, I have an issue that I may need some help with. Below is the sample table: Gencon Module (Source) - GenCon List Inventory Module (Target) - Inventory List Gencon Module is the transactional da…
Hi, I am in need of some ideas, on how to solve a problem I am facing. I have these 3 modules (picture below). The module OC Expected Renewals contains numbers. OC Expected Renewals already pulls in d…
Hi All, I was hoping to get some with a problem that I'm trying to solve. I have a module with a line item that is list formatted. In this module, the 'applies to' is a list that has 7 values. The lin…
Hi Anaplan Modeling Experts, I found it is not that straightforward to play with timeseries data in Anaplan, when the calculation logic for a specific item is referring to the values of itself from th…
Hi, I am trying to write a boolean formula that will create the check mark where the formula finds a match between another line item containing a date and the calendar date on my columns, i.e. item(ti…
I am trying to map a fake time list (months) to the real months timescale so that I can create a time filter off of the real timescale for the fake timescale. What would be the best way to do that? Th…
I have 12 months worth of data, but only want to flag Aug-Dec. I can't do it by checking all the boxes as there are over the 10k limit, so I'm trying to develop a formula where it essentially says, if…
How to apply this formula in anaplan ? CF Inc/dec in Receivables = (@PRIOR(Customer Accounts Receivable)+@PRIOR(Other Receivables)-@PRIOR(Accounts Payable - Intercompany))- ((Customer Accounts Receiva…
I find the safety stock import .csv file is not uploaded in the Sprint. The image I uploaded is an old one shared in the community. Can someone please share the file or assist how can I download it?
Hello, I am working on Strategic Planning where I have actuals for 2019 and I am projecting for 2020, 2021, and 2022. I have a formula where I want to apply a 3% escalation starting in 2021. My curren…
I am trying to map the Anaplan monthly timescale to a fake timescale that I have created. I have a location that has a date MM/DD/YY in which I am wanting to map that to my Month list that consists of…
Hi, My current build has been full of surprises. Right now I need to lookup start dates for new employees, but, the module I am building and the model from where I need to take the data, both use diff…
