-
Can we send email to users who are using gmail using browser .
Hi , My User is not using outlook and they use gmail through browser only .So is there any way we can configure in Anaplan MAILTO function to send email to gmail account . Thanks .
-
Getting a comments (editable text line item) at summarized level
Hi, In a primary module, there are some summary line items (like D = A+B+C) where 'D' is the summary line item. I am using these line items as a line item subset in another secondary module as a list and pivoted as rows. Now the requirement is to enter a comment against each of these summary line item. Could someone please…
-
How to restrict access on line item which is list format
Hi , I have a module with number list as dimension and Country as line item . I want to restrict access of country to users (Cant use Selective access ) .For example ,one user has access to 2 countries ,then that user should see only 2 countries in drop down and should not see other countries if user from other country has…
-
Getting Invalid error in Logic
IF 'Headcount Capacity 2' 'Seatings.Less than 50 seats' THEN 'S' ELSE IF 'Headcount Capacity 2' 'Seatings.50-200 seats' THEN 'M' ELSE IF 'Headcount Capacity 2' 'Seatings.201 - 500 seats' THEN 'L' ELSE IF 'Headcount Capacity 2' 'Seatings.More than 501 seats' THEN 'XL' ELSE 'Headcount Capacity 2' This is refernce to…
-
Forward Weeks of Cover or Forward Weeks of Supply
Thought I would post this here as a method to calculate Forward Cover or Forward Weeks of Supply. A year ago @AnaplanIdeas posted an idea for this which is great. I'd like to expand on this idea and also incorporate @nathan_rudman backward-looking suggestion. Summary: In the supply chain horizontal you may be asked to…
-
Time Filter applies to specific month
Hi, I'm trying to create a time filter that will only ever return current month and December 2020. I've managed to create a filter for both using separate line items, struggling to combine and allow users to view. Any suggestions? Thanks.
-
Circular Reference when using a line item as input
I have a formula that needs to look a specific number of months back. The formula works when I type in the number of months as a hard code in the formula, but not when a use an line item containing the number of months. A screenshot is below. The Maturing Balance formula works. The Retained formula is the Maturing Balance…
-
Level 1 Model Building : Margin and Margin % in Rep02 Size Margin Report
Hello, I am reviewing REP02 Size Margin Report and having issues. The Margin and Margin % are not populating. Is there a reason this would be happening. Is it not supposed to populate? I have put in the formulas and the sums properly (see attached image).
-
Custom Time Dimension / Supply Planning on a daily basis
Hi, For a client of us we're looking into setting up a Supply Planning model where planners have the ability to plan with a telescopic view. Meaning they're able to simultaneously plan on a daily & weekly basis. Ideally we would work with the standard time but as weekends can not be taken into account we're looking into…
-
Last Occurence
If line item is list formatted and if list item choosen is repeating , then how to get the last ocurrence of every list item?
-
Dependent dropdown
I have one dimension "Employee" and want to assign two products A and B. Product A and Product B are two line items formatted as Product List. It is perfectly fine if employee is assigned the first product however, when the employee is assigned product B, then product A should not be visible in the dropdown as the employee…
-
Date Conversion
Hi Guys, I have a simple one to ask. I am loading a Period with a Text format to a Year and Month with a Number format. Example: I loaded a date of Jan 13 to a Period column. Then I need to convert it to Month 1 and Year 2013. I tried loading it as Time period which is the right way but for some reason it is not loading…
-
Variance Analysis between versions without using select
Hi, I am trying to create a variance Analysis for users so they can compare price & volume between to Anaplan versions (i.e Budget & Forecast, Budget & Actuals). This idea is for user to select Version 1 and Version 2 to decide which versions they want to compare. Similar to: Select V1 : XX (i.e Budget) Select V2: YY (i.e…
-
How to calculate cumulative results
Hi,everyone. I would like to calculate the cumulative result of a line item. I think I should use the TIMESUM function, but I don't understand how to use it. I want to get the cumulative result from the date of FROM to the date of TO. Could you tell me the best solution? Best regards. Taku
-
Dashboard View Error
Hi , we sre all getting this error on some dashboards, and can noit work out how to stop it Any suggestions please? thanks
-
QUARTERVALUE Function
Hi team, I've got 2 simple modules with 2 dimensions, Accounts & Time. The source module has the Model Calender with Month as the Time Scale. The target Module has a Custom Time Range with Quarter Totals selected & has Quarters set as the Time Scale. Both Summaries are set to Sum When I reference the source module using…
-
Referencing Batches of Same SKU to calculation QTY of expiring materials
Hi All, I've been racking my brain over this one and I can't think of a good solution. I want to calculate the amount of inventory that will go expired for a given batch of materials, but as we cannot reference another rows easily like I can in Excel, I can't think of a good way to do it. Here are my basic assumptions and…
-
Is it a Bug?
I have a dimensionless module with two line items Line Item 1: Amount (No TimeScale, No Versions applied) - Number formatted Line Item 2: Absolute (No TimeScale, No Versions Applied) = Absolute value of Line item Amount Change the Formula Scope of the Line item Absolute from "All Versions" to "Actual Version" or "Current…
-
Migration to new SKU code
Hi All, One of my client is under IT systems restructuring and migrating to new ERP system. Because of that the SKU codes for ~6000 SKUs will change to 18 digit in a couple of month. In Anaplan we currently have old codes for SKU and there is another numbered list of SKU-Customer combination code of around ~100000. What is…
-
Cumulate Issue
Hi All, I just need a little opinion whether excel is wrong or Anaplan. See below. So i only copied the values so there is no formula. Excel Driver Cumulate formula it adds the Excel Source value and Excel Source Plus value. So its like Sum(Value, PLus Value). The problem that I have is in Excel Driver when they cumulate…
-
Input into different hierarchy level and display balances in one module with Hierarchy and COA dim
Hi, I've been digging around all the resources but could not find any solution to my problem. We are trying to build a legal hierarchy tree (ragged) with inputs into each entity in varying levels and then presenting those inputs in one module with 3 dimensions: legal entity hierarchy tree, chart of accounts, and months.…
-
What's the difference between a model and an algorithm?
What's the difference between a model and an algorithm?
-
Find the minimum contract quantity falling within a contract range
Hi, Hope you all are having a good day so far. I would like to identify the least contract quantity falling within a price list range. if 10 contract quantities fall within a price range then I would like to choose the least from it. The catch is that the contract quantity is a calculated value and it is calculated for all…
-
Weighted Average by variable number of weeks
@rob_marshall I am looking for some guidance on how to do weighted averages based on a selected amount of weeks? Our call center planning is in need of looking at weighted averages based on a variable amount of weeks For example, a user selects the number of weeks they want to average the results by and based on that…
-
Switchover
Hi All, Is there a way to disable switch over in blueprint view for a line item without a time dimension? Thanks N
-
How to calculate % of one row over another row?
Hi guys, I am trying to do the calculation of % of Show Specific / Total Universe and it's not giving me correct %. In the image below, the correct % should be 5401 / 21682 = 25%, but it's showing 4800%. Can someone please advise what I did wrong? Thanks, Jim
-
Sum based on specific value from another column?
Hi All, For line 3 in my module, I am trying to sum ONLY the lines where Total Inventory = Regular (Dimension), how should I setup this equation?
-
Update/add
HI, users should add/update the changes in the module.This should reflect in the Target modules while they submit. Like if already there is employee assigned to company and again if we wanted to update the details of employee how do we do that?
-
Displaying Line items by user or role
Hi, I have an issue I'm trying to solve. I have a module that multiple users have access to. I don't want all the users to see all the line items. I need to hide 2-3 line items for certain users or roles. Another module without those line items is not an option. Is there a way to this? Thank you Ronit
-
Circular Reference Issue
Hi Guys, I need help in figuring out a workaround for Circular Reference. I recreated the modules the best I can and I hope its enough to understand. See below: This is the driver module and this is already working fine in Anaplan. Lets say Row 1 and Row 2 and then Time Dimension. This is the countif module, this also…