
Calculation Functions
Calculation Functions
Discussion List
- HI all, I have a module Fnem00, here we have to Select the Account and program. Based on that we have provided the DCA to enter the values in Fnem01. Now if I delete the Account and program in Fnem00 …
- Hi All, i have a question about switchover Currently the forecast period is started from Jan 23 and i have input a $10 in this period however after i have switchover to Feb 23, the input value will go…
- Hi, fellow Anaplaners I observed some weird behaviour of Anaplan natural rollup (meaning set line item as number & sum as summary method, then parent item will take sum of all its children's values). …
- If the following features could be added to the formula bar in Anaplan it would make model building and maintenance a lot easier! * Colour coded statements and keywords (e.g. IF THEN ELSE, line items,…
- Hi, I am unable to add the right data in Fy 21 and FY 20 in the REP 01 Country Margin Report Module. I have added the exact formula as well but it is showing the correct answer in only the FY 19 rest …
- In an attempt to reduce the size of a line item(used for dashboard filtering), we created a dummy list that contains a small subset of people. The subset of people has selective access enabled. I the…
- Hi Everyone, I have a module which is dimensioned by one list. It has around 60k items. In this module there is one line item (Main_Text). I want to pull a string from this Main_Text line item and the…
- Hi All. I have a Prod model. which has been gone live Aug-22. Now its size increasing every month. Our Total Model size 200 GB .Last month we had 160 GB this month its increase 176 gb. Now its occupen…
- HI All, Why we use summary as formula. what are the scenarios that we use this ? what is the outcome of it?
- Hi, I am using the rankcumulate function but I am getting some really unusual results, wondering if anyone could assist as I have no idea why this is occurring? I have attached the formulas and also t…
- Hi everyone: Module 1: Dim - Entity (Aus 1, Aus 2....) LI - please refer below as (numbers) Module 2: Dimension: LI of first module , Parent of Entity (Aus..) Line item: Amount (which will have the va…
- Input Road 1 France Germany Type A Road 2 France Germany Type B Road 3 France Italy Type A Road 4 Italy Germany Type A Question Hello, I would like to know how to get back into a module the correct ro…
- * Step 1: Create a module for your error messages * Step 2: Create your line item subset * Step 3: Create a System module to store metadata associated with the validations * Step 4: Create a module an…
- Hi Everyone, I have a module dimensioned by List 1 and Time (Quarter). There is one imported line item (List formatted). I want to number these imported cells data according to the quarter. For exampl…
- Hi, Quick sum currently works for cards on a board, but does not work when a card from that board is maximized. This was a feature in the old UX when a module on a dashboard was maximized. We have a g…
- When looking at the page for the rank formula, there is a callout that says "Remember that if a source value is blank, the blank is ranked first for ascending order and last for descending order.". I …
- Hi Friends, What is the command required to break text into multiple lines in a Dashboard.
Move data from fake time period to real time period (For restriction of drop down selection on time)
Hi, I want to move the data from fake week to real week. I tried with multiple formulae and still getting errors. Request your help. Please find the screen shot of requirement below: And I have a mapp…- Can I know if the formulas are right and I need help with the other formulas
- Hi Community ! 😀 I'm learning the training and I completed everything but the formula is what holding me back for the past 30 minutes.. So below is what I have : & from the training I am suppose to h…
- Hi community ! Please bear with me as i have a learning disability. I keep receiving this error message ... I would greatly appreciate the assistance. Thanks in advance ! @Sowjanya @jagadishdash
- Hello all, Can you please advice how to add "line item associated with a single list items"? In the attached screen shot, •MU approved/agreed and •GS approved are list items and I have created a neste…
- I'm not getting any values for my 3 line items after the baseline forecast. I cannot figure out why this is happening. I see growth percentages in my source modules, but they are not being carried ove…
- Hello, please help me define the summary methods of Demand Export Module to match my results with the correct answer from the course. here si my results The correct result is attached
- Hi, I'm trying to create a formula where the End User Input will flow to both the Forecast and Budget Version of my model. The formula I'm trying to use is below. I can get the End User Input to show …
- Hi Community ! 😊 So Im completing the training and Im suppose to have the same page as my screenshot below : But Mines Turned out like this : Some help would be appreciated Thank you in Advance ! @Ak…
- Hi, I am trying to write formulas for this activity: Here is what I am doing: But the results are nor correct, How should I change the formulas and/or summary methods? Thanks
- I am not getting the export as i selected in saved and drop down
- HI All, I have a module there i have saved view for export. when i exporting in module its showing correct data. when i create the action button and run and see the results its diffrerent . please exp…
- Input: ABCDEFranceGermanySpainPortugalSweden Calculate : BCDEOrigin countryFrance (A)Germany (B)Spain (C)Portugal (D)Actual CountryGermany (B)Spain (C)Portugal (D)Sweden Hello, I would like to know if…