-
3.3.6 Activity: Test the Shipping Cost Formulas
Hi! I followed all the steps carefully and answered correctly the questions (test your formulas) but now that I am replacing the offset with POST, I am not the getting any amount for "Confirmed Purchase Order Receipt" unlike in the should be amount. I don't know what's wrong with my formulas?
-
Technical documentation about Ananplan
Hi all, Does anybody know where to find Anaplan current documentation on the following points? EULA / SaaS Agreement / Terms of Use Data processing addendum/agreement Which Cloud provider hosts the infrastructure and where the data is stored (AWS, Google, Azure? Stored in the EU? Which country?) Backup/DR. How our data is…
-
No workspace admin, no access to UX page
Hi all, I'm currently facing a page visualization issue. The model has been set to have three kinds of page visualization: Full access, access to all the page, used by us anaplan consultants Corporate Role, access to all the pages, used by the managers User Role, access to some specific pages only More importantly, the…
-
Dimensions that don't exist yet
I need to dimensionalize a report in Anaplan by Regions we currently don't use. They aren't in Anaplan at all. We have the accounts we need but the Regions in Anaplan are different that the Regions needed for this report. I know I can create the Regions but the only issue is that I do not have the data needed to input the…
-
How can I lookup a line item in a source module ?
Hi, I am trying to pull in a column data (Status) from a module 13DL into the target module 8R. LOOKUP didnt work for me. Help. What did I do wrong? Target module :8R is dimensioned by P Project Data and line items Source module: 13DL has a line item which has a list format of P Project Data ( derived from using Finditem…
-
How to apply logic where we can cumulate the values of list items without time?
Hello Everyone, Can you please help me out in applying a logic where we can cumulate the individual List item. Example: if a person is having 5 sales that he does sale 1 has some revenue, sale 2 has some revenue same as for Sales 3,4,5. In our desired line item: sale 2 value should be the cumulative Revenue of Sale 1 and…
-
Retrieving data from one store to Another
Hello everyone, I have one question regarding a dev I am currently working on. Here is the question : I have a line item that retrieves quantity from a file : Those quantities are splitted through different stores : Now, the need is to merge the quantities of B01EUR and B03USD so that it becomes the quantities of B05USD.…
-
Stock Projection (Stock + Input - target)
If anyone can help me with this: I need to perform a stock simulation by inputting values, as you can see in Mar 24, I do not have enough to reach the Best Estimate (what I need is 261 to reach). But if I input 1000 in Feb-24, I would have 146 + 1000 = 1146. I need to subtract the target for February, which is 261, from…
-
How to pull the annual total from the month forecast module?
Much appreciate if someone can help with this one. Source module: monthly expense list: cost center & expense type Dimension: time (by month, with year total FY23); version (actual & forecast) Line item: expense Target module: Annual summary list: cost center & expense type Line item: expense, budget, variance, % NO TIME…
-
Prior Year Value: Page selector?
How can I view the actuals for a previous year, regardless of the current year? For example, if if July 2023 is selected, I want to see the full year 2022 actuals. Similarly, if July 2024 is selected, I want to see the full year actuals of 2023. My current logic is only working for 2022 actuals. Actuals = Amount [Lookup:…
-
SELECT - two attributes
I try to write a function that selects both a specific version and a specific level in the hierarchy from a list. I know how to use the SELECT function individually on each of those selections: 1) Sales module.Gross sales [SELECT: VERSIONS.Actual] and 2) Sales module.Gross sales [SELECT:Product.Nuts]. How do I write the…
-
How to divide a list item value by the total list items value ?
-
Log of user activities
Hi, We have a requirement in which details of changes need to be captured. For example, when user created a new request on Anaplan, we'd like to capture the user who created this request automatically without user input. Our current design require imports. I'm wondering if anyone has done something similar without imports.…
-
Having more than three dimensions in the pivoting of modules
Hello, Is there a way to have more than three dimensions as rows or columns when pivoting a module? Maybe it is easier with an example, I have to create a report that requires 3 categories on top of the line items, but I am only able to add 2 categories, because the pivoting cannot exceed three dimensions in rows and…
-
Lookup Error message
Hello all, I'm currently working with a model that provides weekly forecasts for all products. My goal is to obtain forecasts categorized by product type (S or W) instead. However, when I attempt to use a lookup, I encounter this error message : "Format of mapping used for lookup doesn't match any dimension of the source".…
-
How to hide line items in UX avoiding repetitive hide UX command
Hi all, I am facing an issue I'm pretty sure many of you already have dealt with. The columns Cost Center, Responsible, Employee Name, Labor Cost are line items. I wish I could show the cost center, responsible, employee name, labor cost line items only for the first project (1-Av-Bc - Argus V1); in short, I need to go…
-
How to clear dependent dropdown selection without error
Hi, I have created dependent drop down list line item. . See below example data entered by user. Activity is based on Project. Activity Project Activity A Project A Activity A Project A Later user changed Activity value to Activity B and forgot to change the related Project. But Project is still having value based on…
-
How to establish many to many relationships?
Hello! I am developing a Demand Planning model for a school book retailer. I need to determine the SKU (the book identification) that each school uses (in order to purchase those SKUs for the stores around the school). However, some schools utilize various SKUs for the same year/subject, resulting in multiple SKUs for the…
-
why is the summary not showing even when its enabled...
i have to refer sum in another module but it shows 0 since the sum is not showing here
-
can we have a multi select filter as a page selector in Anaplan?
similar to what we have in excel filtering…can we use page selectors to select multiple boolean formatted line items. Snapshot attached
-
Importing module
Hey community, hope you can help me with these one. In my Data Hub model I have a module to fed the others which includes different columns such as CCs, Accounts, Entities, etc. For the CCs specifically I create a mapping module which map some CCs to their parent level (these to avoid creating too many cost centers on the…
-
Add a list item from a module
Hi all, I am struggling a bit to find a way to add a new list item from a module. So, I have this module in which I let the user insert the product, the product code and finally the customer group; the final result are three new list items I need to add to the relative list, that is ps01 product (which is a numbered list…
-
Percentage of Parent and Parents Parent
Hi all, I am trying to find a way to calculate the Sales % of a items parent, and also of the Parent of the items parent. Below is an example of what I am trying to achieve,
-
Seeking Advice: Establishing a unified organizational structure & managing restatements
Hello, I work at a company's headquarters, where we use Anaplan for reporting purposes. Some of these Anaplan models have been developed in-house, while others have been created by external consultants. This has resulted in a situation where we have multiple lists containing more or less identical organizational…
-
can build a action that updates current month in time dimension of both hub and spoke?
Hello everyone, Can we create a action that updates current month in time dimension of both hub and spoke. Thanks, Maithri.
-
Add a button to a dashboard
I have dashboards built out for budget owners in the model layer not app layer of anaplan. I would like to add a button that essentially gives the budget owner the option to add an additional FTE to their headcount and plug in the respective salary of the new hire and see the financial effect of adding one additional…
-
Changing formula scope does not re-apply to line items?
I have a formula which was written with the formula scope set to 'All Versions', then realised that I only need it to apply to 'Current Version', so I changed the scope but the data is still showing in the actuals and the forecast (all versions). If i add a new line item and set the scope first, and then use the exact same…
-
Summing only some lines in a list
Hi everyone, It's similar to SUMIFS with 1 criteria as a line item and another criteria as a line in a big list. I've tried SUM, LOOKUP but none seems to work. the error is: This … is not a line item could you please see if you can help? Many thanks, Jesse
-
Cloudworks not working
Hello everyone, I tried to automatize a process through Cloudworks, the process do to following thing : it pushes boolean values from one Line Item in the Model A to a Line Item in the Model B. So i created the action (that i encapsulated in a process) in the Model B, then i went to CloudWorkds and did the correct setting…
-
Level 2 Sprint 3 3.3.6
Hi, I'm having difficulties in the Shipping Cost and Final Shipping Cost line items. The formula I used for both: Shipping Cost: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] Final Shipping Cost:…