In my data I have teammate roles, their names, the month that they were in that role, and the facility that they serve. In one module I have all this information listed out. I included a picture with …
Currently in an Anaplan dashboard, if you highlight cells, you can view the summation of the values (see image below). However, when you expand the table to fullscreen, the summation does not show (se…
I would like to get the averages for a line item using prior year month values. I can use the formula below but I don't like the idea of hardcoding. Is there another way I can do this without hardcodi…
Hi, I want to Filter List by page selector. I have this two tables. Region List is a parent of Country. I want to achieve this below image. When I select Europe in Region table, Country table is filte…
Hi, I want to use breakback function and Write Access Driver. We have Country List which has Region List as Parent. And Users input to "Adjust Lineitem" and it set as breakback. In this table, I want …
Hi, I want to use breakdown function. Breakdown has equal division function as default. (Image is Adjust(normal)) But I want to breakdown by History rate. case) Japan : 1000 * (200/800) = 250 Are ther…
Hi All, I have a model with Week General time settings. Module 1 uses Day timescale and Module 2 has Date formatted line item. How can I lookup line item in Module 1 using Date formatted line item in …
Whether using IF Approved? = TRUE THEN 1 ELSE 0 is good or optimizing the formula as IF Approved? THEN 1 ELSE 0 where "Approved?" is a BOOLEAN format line item. Same goes for, IF Approved? = FALSE THE…
Hi, I need to sum the elements of one column based on an element "text" of another column. This text element isn't in a list so I can't use the function "Select". What formula can I use ? Thanks ! Bes…
I am getting the formula right - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory However, I am not …
It would be nice to have it displayed the action run time stamp or a Boolean check timestamp using a data write action in New UX. we can bring by text formatted line item as we dont have time stamp da…
Hello, This is my proposed formula for the Flag Count line item - taking into account the mapping for both country and product family that are dimensions in the INV02 module 'INV01 Inventory Ordering'…
hello i need help, please !!! I am stuck on level 2 sprint 3.3 activities I don't understand why i can't have the same results that course My results My formulas Level screen reference
Hello everyone 🙂 , we have two model builders who applied the same formula but with a different order, but since it's multiplication and division, the order doesn't matter. Unfortunately, I come acro…
I have Module in DataHub without any Dimension I need to create a column that count distinct (Unique) Value of Agent Program and Agent are in Text Format DateProgram Agent Distinct Agent…
Hi Anaplan! It would be great if when you are entering a formula within a list property/attribute you can select another list item property by clicking on it instead of having to enter the name each t…
is there a way to calculation the NPV on a rolling basis? So basically I would want the NPV to be calculated on a quarterly basis for the current quarter and forecasted quarters. per the screenshot be…
Hi, Is there a step by step guide on how to use the Add version formulas to line item subsets in module blueprint ? I don't see any line item in the left box. Thanks, Tom
Hi, I have an error message that keeps on popping up when I'm trying to create a formula. I'm trying to multiply the two line items together. Please advice. Image is attached. Thank you
Hi, I have a problem I am finding difficult to solve. Hopefully, someone in the community has encountered this before and can provide some clever solutions to this. First of all, the modules I am show…
Hi - I am at the L2 training segment 2.3.10. While my formulas are all correct (I think), I am somehow still seeing an unexpected value as an answer. Screenshots below on my formulas. I'm not really s…
Hello, Quick question: How can I calculate the Volume between FY17 and F21 in the other module? For example, the difference between two years. Note: Just Volume is a line item. Please see the attached…
Hi All, We have a requirement to sequence items in a export and we've been using the RANK function to achieve that in a similar way that is listed in several posts in the community…
Hi, I am trying to do this activity: Here is what I did for DEM04: And this is my export view: There are two problem comparing with the expected result 1. The SKU Code and Location Codes does not appe…
Hi Everyone My import was successful however it doesn't match the guide Here's the result of my mapping Here's the guide Hope to hear from everyone soon!
Hello everybody. i´ve been stuck in this activity since yesterday, a create a Role list, With a top level of all roles, then i import the new data in the SY08 EMPLOYEE DETAILS with the extra role line…
I have a module that we export data from using two system type modules that allow a user to filter their export by version and by year (time) using boolean selection boxes (checkboxes). I want to add …
Hi everyone, My company uses Anaplan for all budgeting and forecasting and we recently discovered an issues as this is only our second year. We have 2 metrics "Bookings" which are sales associated wit…
