-
LEVEL02 SPRINT 3 : Calculation problem
Hello, I am having issues calculating the shipping costs. I thought that my formula wasn't working but it's working perfectly . You can check with SHipping cost per 1000 that the value is correcly imported (65). Then when i multuply this amount by Final shipping amount 8149 i get 532610 ijnstead of 529685 like presented in…
-
Boolean Filter to match List Subset and List in Module
Hi I am trying to create a filter to apply to 'INP Module - No of Frequencies' so that result below can be achieved but am hitting humps. If the North Track and East Track in 'ss NE' matches the Track L2 column in SYS Module, then the Expected Result is that Serv under North Track and Serv under East Track should appear…
-
SELECT command does not work with Version name having number in its name
Hi, I was working to find products ASP for a Version with a variance of 10% between product ASP in other Version. For example, product ASP outlier with version BOQ(Beginning of Quarter) works well unlike EOQ1 (It consists of text and number). 1st formula works well unlike the 2nd one which gives Inval. I believe its a bug…
-
Rank Function (Two Dimensions)
Hi, I have a module with two dimensions (besides time): customer (BA) and sales location (plant). I'm looking to use the RANK function to display the top twenty customers for a specific line item of value (net negative suspense). I want to display the top twenty customers having negative values on a dash, but I'd like it…
-
Level 2 Sprint 3 INV01 - Not 1st week of Timescale?
I have a question on the line item Not 1st week of Timescale? in the "SYS01 Time Settings By Week' module of Supply Chain Model. I am trying to understand the formula for First week of the timescale. Whatever i try to generate for this lineitem is based on the current period of the timescale. What i am trying to understand…
-
Referencing values across Versions
Hi Team, We upload our full SF account list to our Customer Account list at the start of the planning cycle and I wish to delete out accounts which do not have revenue in any versions once the Plan has been completed I'm created a module dimensionalised by Customer Account & Versions which returns a Boolean if the Customer…
-
Sum on Clone Day Period List
Hi Team, I have created a Clone Day Period list as I require to RANK data that is dimensionalised by Day but I cannot SUM the data into the Clone list when using the mapping Time(Day) with the Clone Day List as a property Source Data dimensionaled by Time(Day) Target module dimensionalised by Clone Day List and referencing…
-
Formula to pull data from one member to another of the same list
Hi What formula does one use to pull data from Member1 to Member2 of L1 L1 |-- M1 - 10,000 |-- M2 or from Actual to Budget ?
-
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…
-
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…
-
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)?
-
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…
-
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…
-
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
-
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
-
Formula Inquiry
Hi Guys, I just want to ask something. Our client has an excel report template, its more like Operating Statistics type of report. It basically counts values per month and it is usually referenced to another cell in their report. After checking the issue sent to us I notice one 1 line item (actually it is an entire year)…
-
Bring weekly data into a daily module
this should be easy but I just can't get it. I have a weekly module with inventory cases...snapshot is done on Wednesdays. Anyway trying to take that snapshot and have it show up in a daily module on the Wednesday date. Any help would be greatly appreciated. I'm trying to avoid making the inventory cases a daily module.…
-
Level 2 Model Building Sprint 3 INV04
Hi, Could someone please help me with the module below? I am struggling with the Percentage Full result that I get and I think it is because I am doing something wrong in the Beginning Inventory line. I am pulling BI from DAT01 which gives a straight line across all months. What am I doing wrong? I also could use a…
-
Error in Importing
Hi, guys! I always have this problem when I am importing my data in Anaplan. I tried all the methods I know but I can't solve this problem. I am trying to upload this data to my budget version but to no avail. Hope you can give some assistance! Thank you for the help!
-
Query on Parent function
Hi Guys, Curious - Why wont we use Parent(Item('G2 Country')) for line item 3 (Region)? Thanks
-
Rollback caused by "Is Summary"
Description of the enhancement: When a user incorrectly selects "is summary" for any line item with non simple formulas they hit a rollback. A rollback consists of a model closing, opening, reapplying a changelog, and saving. Can we look into a solution to capture that the formula isn't a summary line item before it causes…
-
Calendar Conversion: How to Map 445 to Gregorian in Anaplan
Navigation: Retail UAG Home | Forum | Get Started - Content Directory Convert 445 Calendar to Gregorian Calendar Hi Anaplanners! Today I was really fortunate to have an article posted in the best practices forum. For the retail industry, this is the first step to connected planning between merchants and finance…
-
Level 2 Model Building Sprint 3 INV01 Module
Hi! I am struggling to complete the INV01 Module Line Item Formula Details. It seems like everything is working except for the "Confirmed PO Delivery" formula. Below is the formula I have and the result I get: IF PO Submitted = 1 THEN OFFSET(PO Submitted, -Shipping Time Weeks, -1) ELSE 0 I've found similar questions in the…
-
Filter Crash in Production
Hi, I have created a Time filter for a Dashboard and Export view in Dev Model. But when i push that to Production every time the Filter gets crashed in the Saved view, so i am not able to get the desired layout in the Dashboard and Export File. Can you let me know where am i going wrong. Attaching the screenshot from Dev…
-
Need to lookup Employee name basis the Employee order
Hi, Source module has All Employee list and basis their "Joining Date" (Line Item 1) "Rank" (Line Item 2) has been determined, in Target Module I have "Employee Order" (Line item) formatted as number. Is their any way, basis the "Employee Order" in Target Module I can get the respective employee’s name from the source…