Hi I'm trying to solve for the following: The screenshot below shows the two columns am trying to accumulate, Rows are the A1 Accounts dimension. The next screenshot shows I have a column for Country …
Hi Anaplan Community, I am currently using the formula below to take a moving average of my prior year value. So for instance if this formula is in my April 21 month, it is summing April 20 to April 2…
Hi, I was taking the level1 certification exam, creating REP04 Employee Expense Summary. Here are my formulas: Salary: 'EMP02 Employee Expenses'.Salary[SUM: 'SYS08 Employee Details'.Region, SUM: 'SYS0…
Hi, I got some problems when importing SYS08 Employee Details.txt file while taking level 1 certification exam. I attched my screenshot. I would be appreciate if anyone can offer any suggestions. Than…
Hi, Need help replicating this Excel Formula. The Anaplan formula we created is not working. Excel Formula =IF((WR20+WR26+WR27+WR29+WR28+WR5*0.95+WR31+WR32+WR35)-WR40>0,IF(WR29+(WR5*0.95)+WR31+WR32+WR…
There are so many things that I loved about new modelling experience but here are my top two picks which I loved the most. 1. Ability to open Lists, Line Item Subsets, Modules and Dashboards in their …
Kindly refer attached screenshot. Am trying to figure how does one populate the boxed column with the value in the cell (1,414). I am already able to do something by looking up a SYS table I construct…
Hi all, I'm checking my work for the INV01 module and my numbers are slightly different than the ones provided to do the check. Here are my numbers below: Here are the numbers provided to check your w…
Hi need some help on the MIN function as I can't seem to get it to work even after going through the Technical Documentation. Attached at the relevant screenshots: SYS08 has the MIN formula I'm trying…
Hi Team, I am facing 2 problems while importing into the numbered list from my Data hub model: 1) it's showing an Invalid Parent error. I have used Parent code while importing, Please suggest how to r…
I took over a Headcount model that was built by a consultant and it uses LASTNONBLANK on a numbered list. I'd like to confirm my understanding of the function when used on a numbered list. Here's some…
I am in the process of creating a Data Hub, where we will be getting multiple files to create lists in the DH. I need to consider creating the flat lists as either numbered or regular list. For the li…
Hi, I have four line items(Text1, Number1, Text2, Number2) I am trying to concatenate if those values are not blank or not equals to zero. See below formula. But I am getting formula invalid error. Pl…
Hi, I'm trying to replicate the Excel Formula in Anaplan below. I'm trying to use the AND function, so i made two Boolean Line Items and combined them to satisfy the condition. The formula worked but …
