HI I have a line item which contains all the cashflows I require for the IRR calculation, but I need to have the cashflows against the last day of each period to get the correct IRR result. In order t…
Hi kindly refer the following 3 screenshots: 1. A2 Account>Product# List 2. DAT02 PY Revenue to CY 3. Check Build Check Build is what I'm trying to get to but before doing so I need to figure the righ…
Hi All, Hope everyone is doing safe during this pandemic. I'm trying to apply filters on time dimension on a standalone basis, but unable to do unless I bring in other dimension to columns. When I cha…
Hi. Good Afternoon. We currently have a rather large Model that serves various areas of the business. Currently all payroll related items are visible and we would like to lift and shift these modules/…
Hi All, I have a scenario, as follows: Module 1 : To get Headcount in this module Dimensions: L6 hierarchy, L6 Flat List(same hierarchy as a flat list), Cost Centre Line Item: HeadCount Time by month …
I'm seeing some unexpected behavior in a Lookup formula that is referencing a period formatted line item. When I manually select a value for Current Year, my lookup formula performs as I expect it to.…
Hi, I want to be clear about the definitions of different properties of Lists. These properties are - Referenced in Applies To, Referenced as Format, Referenced in Formula, Next item index? Could you …
Hello All, Am I the only one surprised by the new blueprint view (the order of columns has changed) and not being able to find any info on Anaplan community?
Hi all, I have some data with various dimensions - one of which includes 'Colours'. I've also got a matrix between Colours and Cities separately (e.g. in the attached) which allocates Colours to Citie…
Hi, We need help trying to write a formula for a value to show on only every 10th of a given month. Also need to consider that the weekends do not count and would fall into the next business day. For …
Hi, We are trying to pick up a Line Item Balance from the previous end of the month. For example, for the month of Feb, need to see the ending balance that is at the end of January.
Hello, I have run into an issue for which I could not find any documented limitation or bug, but I think I may have hit one. I am looking for a solution to the following scenario: Let's say I have a c…
Hi, Hope somebody can assist me please so I can progress further on the exam. I am completely stuck after exhausting all options this morning. I picked Column 2 Departments - map to E1 Departments I p…
Does anyone have any additional information on the upcoming release on 4/24 that will allow for calculations to be driven by the User list? This sounds very intriguing, so any intell would be greatly …
POWER function is unable to calculate all equations correctly. Cube root of '-8' is '-2' But when I tried the "POWER(-8, 1 / 3)" calculation, it resulted as "NaN" (shown in Image)
Hi, Need help creating a formula that pick's up the moving average for a number within 6 business days. Example) The amount for a line item over the past Weekdays were 1, 4, 6, 8, 9. I want to forecas…
Hello, I believe I am running into an issue where some formulas are using the Divide logic and running into NaN when dividing by 0. Does anyone have any reccommendations when converting NaN to 0? The …
Hello community, I have a question concerning the task "Import Shipping Expenses into OTH01 Module" included in the Level 2 conclusion. The preview of the import doesn't show the numbers of the shippi…
