-
Why am I receiving the error "Not a recognised line item or list member" in my example?
Hi Anaplan Community I have two modules (“Allocations Stage 3 Mktng Media Allocation Result” and “Allocated Expenses”) that I want to link together but I am getting the error “Not a recognised line item or list member”. Below is the blueprint of “Allocations Stage 3 Mktng Media Allocation Result” Below is the blueprint of…
-
Help on circular reference with POST
Hello, Do you know if it's possible to force the formula POST like LAG with STRICT argument. My use case to be able to POST value in the future for stock equation. If I use LAG(value , Leadtime , STRICT) or POST(value, 2) the formula are ok If I use POST(value, Leadtime), I have a circular reference. So I try to help using…
-
Notification error
Hello, Sometimes I get this failed notification. In some cases it works, sometimes it doesn't.
-
UX related question!
Is it possible to have the arrow marks as shown in the screenshot below? Like, it should not be a fixed one, it should be dynamic. If yes how this is achievable?
-
NPV with Rolling Period
Hi - I am trying to build a module with an NPV calculation which in each month calculates the NPV of cashflows starting from the next month until the last time period in the module. So in Jan-24 it would calculate the NPV with cashflows from Feb-24 to the end of the module. Then in Feb-24 it would calculate the NPV from…
-
I am hearing about custom versions these days and would love if someone provides an example of same
I am hearing about custom versions these days and would love if someone provides an example of same. Does we create any list for version or the versions tab for acheiving this
-
Plan IQ
Hi all, i have been facing an issue while doing the set up of PlanIQ (followed the tutorial on Anaplan Academy) I am stuck at the same point, when it needs to run the Forecast Action. Do you have any ideas on why it is always displaying the same errors ? I was told to put Internal Access the the list i use (but i didn't…
-
Formula to return the latest date and hour
Hello, I have a list with exports date and hours and minutes. I need a formula that will allow me to show on the UX, the latest date with hours and minutes. Is there such a formula? Thanks
-
I am not able to Login to my Anapla to build models
I can login to view course, but when I try to login via this link it is repeatedly saying the pwd is incorrect. Im also not able to set it right as Im receiving no email. Do we need a business email or account to access this?
-
Export with different dimensions
Hello, I am trying to make an export. In my Export, I need to show on a column category Int and category Ext (both on same column). The problem that I have is that the domensions that I need to use for this information are in the Children of my dimension. Let me make a scheme; Dimension A - the one I have to use Dimension…
-
Import Financial Transaction Data
I have a financial transaction file I receive every night. This file contains multiple rows that contain the exact same data in each field. Is there a way to import these rows without failing the duplicate checks?
-
L2 Course - Supply chain model INV05 Shipping Export
Hi, Any expert please help , I am stuck in Importing G3 location in "INV05 Shipping Export" module , I alreay crteated Subsidery view doe CODE line item , in this Module , but while importing Data from G3 location List , it is ignoring the Parents like "US", please help me to understand what is wrong in steps , please…
-
Circular Reference Problem
Hi All, I am having a circular reference issue in my calculation. Module A : Is dimensioned by Cost category List, Cost Center List, Time and Custom version List. (source module for forecast) Module B: Contract List and Time and Custom version List. (source module for Actuals) Module C: Is dimensioned by Cost category…
-
delete
-
how to average on roll up
I have a module where I have sales per country. I want to average sales and not add when I roll up to region or when I chose region from drop down. How can I do that?
-
Is there any way out restore the history of QA model without breaking ALM?
Hi All, We have one case , where we need to restore the build & Data pushed in QA & Dev Model. Thinking of following Approach . Please advise if there is any gap or other way out : QA to be change the Deploy to Standard mode Restore the QA model from required History ID Post the successful of restore the QA will be get…
-
3.3.5.3 check your work numbers are out (most likely Dem03)
Hi team, Working through the level 2 model builder course and have hit a snag. My Dat03 Historic values is populated and working as intended with the forecast year pulling the value from the previous year I believe my demand forecast is also working as intended with FY21 pulling from FY20 My issue is my final forecast is…
-
How do I use a line item formatted by a month for mapping in a column dimensionalized by time
I have a value (in this instance it is the number 13 in January 24) that I need to populate in the line item below it in the month of February 25. The entire module is dimensionalized by time (month). The Feb 25 formula is an add months function that references an input from a different module based on the quarter of the…
-
Formula SUM
I have A List of Farms - 'FarmNames' - showing the Farm name, and a Property - 'Shop NameShop Name' -which shows the shop the farm serves. A module - 'Farm Apples' - showing the name of the Farm, and the manually entered number of apples by month for the past two years, where apples is the only line item. I want to show -…
-
How to Bring in Value from Other Module
Hey Everyone, I've been working on Anaplan going on a year and still working to build on my modeling skills. I ran into an issue with a live production module we have. I have two modules I'm dealing looking at: Module A - Dimensioned by tiers (Range for achievement bounds), E1(Employee list) subset on a component type and…