-
FX Rates Conversion
I have two list one is Local currency and other one is Reporting Currency In Local Currency I have SGD and USD but in Reporting Currency I have Local Currency and EUR as list items. The Data is coming in the Input FX Rates via the Hub and the rates are update monthly and then the Data flows into Data FX Rates modules which…
-
Button
Hello Everyone, I have a question. The button below "Show Accounts without Category mapping" but as you see in the table "List of Accounts and Mapping", accounts are showing up that have category mapping. Does anyone know the possible reason for this and potential solutions on how this can be resolved?
-
Limiting Cells to Specific value
Is there a way to limit the value of a cell to a specific range, say between 0-100%. The end desire is for anything input that results to a total exceeding 100% to cause an error or a message for the end user.
-
List Formatted Line Item-Dependent Drop Down
Anaplanners, I have a line item which is list formatted, wherein end user selects a list item. List: R3 Category List: List Items Important Semi Important Not-Important with a top level item "All Categories". Problem: User is also able to select "All Categories", which is actually a top level item and should not be the…
-
Movingsum Function Workaround
Hi Anaplaners, I'm have 2 line items Margin and Moving sum doing a MOVINGSUM on a line item moving sum. And I would like to capture in my line item where movingsum is done. I would like to calculate MoM Average between 2021 and 2022. And When MoM margins differ by more than 30% - I will replace the value with the margin…
-
Dates and time intervals
Hello, I have a request from my sales team to implement a discount simulation in our sales analysis model. To be more specific. I have a model with sales data by day/customer/product. In a different model account managers will input a discount rate by client and product with a validity date, meaning I will have a start…
-
Missing Customer from Customer Hierarchy in the Spoke Model but not in Data Hub
I have a customer that is located in our spoke model, but it is not show in our data hub where the customer hierarchy lives. There is a daily process to push the CH into the spoke model. The client also stated this customer has been around for years and should be present in the hierarchy, but the source file does not have…
-
CAGR Formula Issue
Hi, I would like to write a CAGR formula in Anaplan and don't know how to go about it. Below is the formula. (Ending Value/Beginning Value) ^ (1/No. of Periods) – 1 Each time I try this formula Anaplan throws an error invalid formula. It seems Anaplan does not recognize this ^ sign. Please any workaround or suggestion how…
-
Need past /previous active value
Hi, I need help here to get the associate last active plan as complan in one of the modules'. If I use current date in lookup its taking the compl plan as blank Thanks & Regards, Swapna
-
Level 2 Conclusion INV05 Shipping Export
@Misbah Shipping Costs = 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] This formula for the shipping costs line item is giving me '0' as values. Is it because the formulae I have entered is wrong?
-
4.8.2 Activity: Import Data into E2 Employees# List
Hi All, Has anyone completed exercise # 4.8.2 Activity: Import Data into E2 Employees# List? I am not able to procced with this, can anyone j
-
Level mismatch in trying to bring data
Hi I have this scenario where I need to bring in data from a source which is dimensionalized by Product L3 (leaf) level and Account to a target which is dimensionalized by Product L3 (leaf) level and Area. Mapping table has Product L1 (Top level of Product) and Account. It has Area as list formatted line item for mapping…
-
Calcuation of subsets as my allocation basis
Hi guys, how can i get the totals of my subsets in my formula so the totals of my denominator will only be the totals of the subsets? Thanks in advance.
-
Max Value for a Line Item on a yearly basis
I am trying to find the max value in a different line item for any given year, all in the same module. time is in months so my start month would be january and end month would be december. so for 2023 I want the max item, for 2024 I want the max item, and so on and so forth.
-
Update Historic Volumes for Baseline Forecast
Hi Im trying to build the volumes for baseline forecast and below is my formula resulting in the following error IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast…
-
Omit the calculate lineitems by using Lineitem subsets
Hi, I want to omit calculate Lineitems by using Lineitem subset. I have these Lineitems. I have to calculate each(A,B,C…) error(= Forecast - Actual) . But in this table , I have to create at least 4Lineitems and input formulas. Category Lineitem Value Forecast A_forecast 100 B_forecast 10 C_forecast 200 ・・・ ALL_forecast…
-
Need help filtering a Module
Hi Community!! I am having issues in one of my Modules and Page, as I need to filter out groupings of Country/Region/Area depending on the Territories the user has assigned. Can anyone provide advise? I have tried with DCA but I cannot seem to get it right. Screenshots attached. Thank you!
-
Level2 Sprint3 3.3.5.3 Check Your Work
Hello all, After inserting the formulas to INV01, my numbers aren't exactly the same as the screenshot on the instruction. Where I might've made mistakes? This is my blueprint view:
-
Joint Deployment Blueprint
Hello, In Anaplan Way training (The Pre-release Phase) the Joint Deployment Blueprint document is referenced, but the link does not work. I also searched but could not find a result. Is this document updated and renamed? Best, Murat Akkas Excerpt : Joint Deployment Blueprint for Anaplan employees and partners–Anaplan and…
-
Mail anaplan report to email as attachment
Hi, Is there any possibility to schedule anaplan report everyday as attachment to user email…
-
Summary settings to Formula Issue
Hi All, I have a module dimensioned with 4 lists, version and time. In one of the line-item I have this formula below, which has a division:- IF ITEM('L2 One-off Components') = 'sys99_Lookups'.Care THEN 'dat20_One-off Credits Actuals'.Revenue / Days in Month ELSE 0 The issue I'm having is that when I go to the summary…
-
How to refer a properties in formulas
Hi, How can we refer properties in formula
-
Level 3 Sprint 2 - 7.3
Hello, All my formulas required for Activity- 7.3,Level 3,Sprint 2 appear to be correct. Kindly confirm the Net Commission formula. As the figures I have arrived differ from the activity screenshot.
-
Better Formula Editor for Anaplan; A Chrome/Firefox/Edge Extension
Hello all! A while back I made a Google Chrome and Firefox extension that enhances Anaplan formula editing by using the Monaco editor (currently 700 users). This is the editor used by Anaplan's new modelling experience. My extension works with this new experience adding enhancements over and above what Anaplan have done.…
-
To Select Q1 (Boolean checked) - From the Input year
Hi All, Need your help! I have an input Line Item Say "A", Year Format. I selected FY23. Now i want only Quarter Q2FY23 to be selected. (Boolean checked). I do not want rest of the quarter to be selected. If the input will be set to FY24 then i want Quarter Q2FY24 to be selected. How this can be achieved? Thanks.
-
1.4.3 Activity - Line Item not showing
Level 2 Sprint 1 - 1.4.3 Activity to create/import SYS12 SKU Details. I created and imported all items successfully, and I can check all records are loaded properly. But by some reasons, I cannot see the last line item, Distribution Center' from the view. What am I doing wrong here, can anyone please help?
-
Schedule vs. Snapshot of Line Items
I have a schedule with two line items below showing exactly how the parenthesis should be. When the snapshot is taken, the parenthesis shows differently (second screenshot). Does anyone have an idea of why there would be a difference in the line items after the snapshot has been taken?
-
How to spread a cost from a father to his son in the hierarchy?
Hi all, I am having a hard time spreading costs along the hierarchy. My hierarchy is composed this way: BU responsible BU R&D project What I am trying to do is to spread a general cost across each BU using a driver and then to spread that BU cost again across its R&D projects using a second driver. The drivers need to be…
-
Regarding 'Applies To' order for Modules
Hi, I had been reading about this article on community. There is a paragraph that says I am looking to understand the reasoning behind this, how it contributes to performance improvement if this order is followed. Regards, Aakash Sachdeva
-
Advice wanted
Hi, I have expense list (5 list items) and one line item (Key fig list formatted).So for each expense list I need to assign one key fig. Suppose for travel expense list item If I have assigned Key fig1 and for the next expense also i have assigned key fig 1 then it should show in blue color indicating that each expense…