Modeling

LEVEL 2 SPRINT 2 format issues
Hello I have a format problem in this module. Instead of having 58.88 for example like @Lkishko , i have 5,887,728... like shown below : Insted of having this format : Any help ? Thanks Younes
Known Issues with using POST and IF??
Hello everyone, @Misbah @JaredDolich @rob_marshall If you know there is an issue with using POST with IF then please let us know, if you don't please read on. Context: We would like to move a value from the current period in a line item to another line item x periods ahead under a certain condition. IF Condition is…
Line Item Subsets and COLLECT() function with calculated % Values
Hi Everyone, I have a reporting requirement which I cannot seem to perform due to limitations on Line Item Subsets and the COLLECT() function. I have a Line Item from Source Module A which calculates the % value of one line vs another Line Item (% calc, summary is set to formula) in the same Module. I've created a…
NEW UX: Easily create New board / worksheet page option at the bottom of a category
When building out pages in the New UX, it would make things much smoother on the builder if you provided a "Create New Board Page" / "Create New Worksheet Page" under the last item of a predefined category (i.e. the red box on the Screenshot) In my example, clicking the red box should allow me to 1. choose a page type, 2.…
ANY Summary on Time - Day Dimension
Hi Team, I have a module dimensionalised by Time - Day & have a Boolean line item where I need to be able to set the Time Summary to ANY but I keep receiving an error when I try There is no issue with using ANY for Time Summary if the Time - Months dimension is used but there seems to be an issue when using Day Any ideas…
Best Practices for to define list in Properties vs Modules
Hi experts I am looking at the benefits of defining list in Properties and Modules. Eg. The Pack Type Size members (Size) are to be tied to a SKU. There will be inputs at Size (100g, 200g etc) and Pack Types (Small, Medium, Large) and calculations based on these inputs. I thought I read it somewhere that it is better to…
Planual Explained - Day 18
"Rule 2.02-08": Article 2, Chapter 2, and Rule 8 – “Never use SUM and LOOKUP together”. “SUM and LOOKUP used in the same expression generally cause large formula calculations and may cause intermediate relationship calculations especially if Time is a dimension or when the source and target structures are very different.…
Weighted average, similar to sumproduct in excel
Hi all I have 4 line items vis. Actual demand, D1, D2,D3, Forecast demand. Having monthly time dimension for FY 20. Need to calculate Forecast demand for each month based on this calculation Forecast for April 20 = (Actual demand for Jan 20 * D1+Actual demand for Feb 20 * D2 + Actual demand for Mar 20 * D3)/ sum D1 +D2+D3…
Transportation Planning
Hi, I am looking for a standard demo or Model for transportation planning published by Anaplan which is accesible to all. Thanks and regards Ruchir
How to aggregate of data with different dimensions across modules.
Hi everyone. I have two modules. Each module has different dimensions. And I would like to aggregate these modules to one modules. Please see below: I assume that it will be solved by importing data between modules. But I don't know the specific solution. How can I solve the problem? Best regards, Taku
Version Budget formula
Hi The Current Fiscal Year is Jan 2020 to Dec 2020 No of Past Years : 1 No of Future Years: 1 Current Period: changes monthly For a Sys module, what formula (Boolean type) can be used to select the months for Jan 2020 to Dec 2020 (even though Current Period changes)?
Module line item formula not working
Hi I am trying a simple formula to populate the line item 'Destination Org (Source)' in my module 'Comp Incoming PR/PO'. The formula is comp_pro_po_supply.Destination Org. Any help is appreciated. Thanks Regards Prabakaran
Planual Explained - Day 17
Below rule is connected to the rule explained in Planual Explained - Day 16 - Anaplan Community Go through it before you read further. "Rule 2.02-05": Article 2, Chapter 2, and Rule 5 – “Create “joins” in smallest hierarchy”. “If a text string join is needed, create the joins in the smaller hierarchies first to minimise…
Item name must be mapped-error message
Hi I have the list comp_pr_po_supply and trying to import data from the datafile in my computer. During mapping, I am getting the message ,Item Name must be mapped for the property comp_pro_po_supply. I assume I am getting this message because comp_pr_po_supply has been setup as a list item. But, I don't find that in my…
Planual Explained - Day 16
"Rule 2.02-04": Article 2, Chapter 2, and Rule 4 – “Text Strings”. “Treat text strings with caution. Try and avoid multiple joins and split common joins to separate line items”. It goes against PERFORMANCE, LOGICAL, NECESSARY elements of PLANS if you wish to go against this rule Here is how it was done in Pre Planual Era:…
User Access Summary - Queries
Hi Team, Getting my head around the User Access rules for End User (not Workspace Admin) & slightly confused by the below table on Anapedia The 'Import/Export' item is tagged as 'Role-Based Access' but what access is this referring to? I'm assuming it is referencing the Module access and if so why isn't the item above…
Referencing Line Item data (from module) to a general List in another module
Hello members, Seeking a quick help from all. I have a list 'Roles' which is being used to define different categories of roles in an organization (refer attachment 1. List - Roles). In module 'Employee HC L1 (Actual+Forecast)', calculation for headcount is being done for each of these roles. However, the dimension in this…
Group by/sum alongside multiple attributes
Hello Community, I'm facing the below problem (probably there is an easy solution, however I'm too much immersed into it that prevents me to find it). 🙂 I have an excel database where I have several attributes and a value in the columns. I created a unique key manually in order to upload it into Anaplan. So now I have in…
Finditem formula invalid
Hi I am trying to use the FINDITEM formula for one of the line item in my module. Following is the formula used: Organization Code LF = FINDITEM(OPSdb Site, Organization Code LF). Please refer the screenshots attached. Any help would be appreciated. Thanks Prabakaran
Business Units in Finance
Hello! I hope you are great! I need your help with some tips: We have multiple business units (BU), some with specifics characteristics and others with similars and we need to consolidate the financial results of all company. Also we analyze the relationship between financials results and KPIs. What is the best practice?…
Aggregation of Text Comments up a hierarchy using TEXTLIST
End goal is to be able to enter and aggregate text formatted comments up a hierarchy. Entry should be possible at each level, with prior results appended. I feel like I should be able to use TEXTLIST in the Summary: Formula for the line item and have it roll up the hierarchy on its own. I have not been able to figure out…
Circular Reference - IRR
Hi All, I've encountered Circular Reference in a calculation that involves IRR formula, for which I think is an illogical treatment of Anaplan. Please could you give some advice: The calculation is as following: Relation 1: Operating Results (ORt) = Operating Income (OIt) x Adjustment Factor (AFt) Relation 2: Adjustment…
Module Line item
Hi Would appreciate any help here I have a module ' Comp Reservation Details' which is mapped to the list 'comp_reservation_details'. I have entered the formula for the module line item 'Reservation ID' as ' comp_reservation_details.Reservation ID'. The values are getting populated in the column 'Reservation ID' as…
Conditional Formatting For Versions
Hey , I want to apply Conditional Formatting for one of the Version that is Variance not for line item so is it possible in anaplan ?? because we have only experienced to apply conditional Formatting on Line Items based on Values.
Change structure List
Hi Teams, I have data using List L3 but in next month(Feb 20) the structure will be change, but structure and data in previous month(Jan 20) not impact, like a picture bellow can we do that in anapan? Thank, Panji
Line Item Switchover - Formula Error
Hi Team, I'm receiving a Formula error when I turn off the Switchover on a particular line item & I can't understand what is driving the error The error occurs when I turn the Switchover to FALSE in the Calculation image below Any ideas what would be driving this? Error Calculation Reference 1 Reference 2
Missed the Anaplan Live!: Anaplan Helps Q&A?
Did you miss our first Anaplan Live! Spotlight event? The recording of the live discussion is posted here! In the live event, our presenters discussed all things Anaplan Helps! Watch the video to learn how the program is helping support customers during this challenging time and hear from MAs about the applications they…
easier way for data entry validation and dependent/filtered lists
Noticed this when trying to create an end user model and wanting to only allow valid data entry.... While there is a way to create dependent filters for lists in modules, in reality it is not intuitive and (in all likelihood) too time consuming for most users to attempt. Especially with several dimensions this adds a lot…
Add Test model to existing ALM
Good morning everyone, We are currently in the process of adding a test environment in one of our Workspaces. The target model is already deployed, and an ALM between the development model and the production model is already in place. However, we cannot simply duplicate our production model and integrate it into the ALM as…
How to use SUM function between modules
Hi everyone. I have a simple question. I would like to calculate the total cost of staff from a module that inputs the cost of staff for each month. Please see belows... How can I solve it? I don't know better idea... Best regards. Taku

Modeling

Discussion List