-
Converting Serial Number to Data Format
Hi, How can i convert serial number to date format in Anaplan? Thanks in advance for helping. Tom
-
Problem with replacing SELECT with LOOKUP
Hi everyone, I am replacing SELECT functions with LOOKUP as a part of model optimization (2.02-14 Avoid using SELECT). I did it lots of times and they worked but I am struggling with couple of them. My approach is that I use mapping module to use LOOKUP instead SELECT. I add list formatted line item and select the list…
-
Invo5 shipping costs
The above image show what has to be done I have attach the data i am getting for shipping cost is wrong I am not able to rectify please help me out what i have done wrong .
-
INV01 Level2
I have attached screenshot ,what booleans I must have checked in INV01 so that my module will be ready for further calaculatons or whatever changes I should made in this module to make it calculation ready.
-
Level 2 Sprint 3 3.3.7.2 Add DCA to INV01 Inventory Ordering
Almost completed the work Just confused regarding my work plz suggest if I am wrong 1. Should I use "Submit Purchase Order Request" line item as formula in AD02 Inventory Ordering for Overrides "Submit Purchase Order - Write? " OR 2. Should I use line item "Submit Purchase Order - Write? " from AD02 Inventory Ordering…
-
Ability to Select Isolated Cells in Quick Sum Bar
When using the quick sum bar functionality (https://help.anaplan.com/anapedia/Content/Modeling/Navigate%20Anaplan/Quick%20Sum%20Bar.html?_ga=2.86794650.366156822.1550101511-1666663741.1546456255), you are currently only able to select "blocks" of cells (a series of cells in adjacent rows/columns). It would be useful to…
-
How to avoid Circular Reference
I am looking for a solution on how to write a formula that takes the value for 1 and Jan 21 and adds that value to the answer to the formula in cell 2 and Jan 21. The formula I have currently is the below. What is in bold is what I need to figure out. IF Financial Projection Time = Financial Projection Time.'1' THEN Sales…
-
Is Something Wrong With my Role List? Level 1
Hi, So while trying to update my Emp02 Employee Expenses module calculations for bonus, car costs, phone costs and medical costs to reference Emp03 Employee Drivers by Role module, I get this error: "Invalid error for 'EMP02 Employee Expenses'.Bonus: Automatic sum of 'EMP03 Employee Drivers by Role'.Bonus % over Role…
-
'List Item' Scope on Formulae
Would it be possible to implement a 'List Item' scope similar to Version Scope against line item formulae within Anaplan. My thinking here would be to allow some list items to be driven by inputs, and other list items to be driven by a formula. This would be a huge enhancement, but in than vein I am unsure as to how…
-
Summing based on another modules field
Hi team, Hopefully a straight forward one. I have 2 lists. Campaign and Show ID Multiple campaigns can have the same show however they are not within the same hierarchy. I have a module INP01:Campaign Details that has the Show ID as a line item - not all campaigns have show IDs. I have another module INP02:Episodes where…
-
Data not matching In inv01 inventory ordering
I am stuck on this module from last 2 day but not getting how to get data correct my formule are correct The image for data what i have got is below
-
Select value from future transaction
Hi, I have a module with a number of transactions for different entities. For all of these entities, I have a Unique ID (UID) and a valid from date. I also have a line item that uses the RANK function to rank the transactions. See picture below. Now to the issue; I need a value in the Valid To line item. This value should…
-
Converting "Month 1" to a date
Hi everyone, I am currently building a project planning scenario analysis UX and have designs that use the line items "Month 1-18" to decide hours available by team. There is a button where we can "create a project" and the "start date" is entered. Is there a way to convert from months 1-18 to actual dates using the start…
-
List subset from formula
I'd love to have the ability to create a list subset from a formula. That would give a great way to pre-filter and limit sparsity in modules.
-
"Missing" argument from "SUBSTITUTE" formula equivalent vs Excel
Anaplan's "SUBSTITUTE" formula has three arguments whereas excel's has a fourth optional argument that would allow for much simpler identification of specific substrings within a string that varies in construct: Anaplan = SUBSTITUTE(Text to search in, Text to find, Replacement text) Excel = SUBSTITUTE(Text to search in,…
-
Data not matching
This is the desired output the image below is one i got after completing inv01 inventory ordering i have error in 1. Ending inventory data for week3 and week 4 2. Shipping cost 3. Final shipping cost 4. Shipping cost variance Please help me
-
The Page shows the correct value but when drilled down it picks up a different value. Why is it so?
Hi Community, I have an issue where in the Page displays the correct value but as soon as I drill down it, it picks up a different value and shows a different result from that of the page. Is this an Anaplan defect?
-
Number of cells count conclusion exam
Hello everyone. I have successfully completed my module builder certification training. There was question during the exam that I was not able to resolve. This was related to the cell count for the export model to transfer the final demand from the supply chain model onto the FP&A model: This is the formula I used to pull…
-
Data error
the above image is in the lesson which we have to do This Thsi image The above image is what i have done after applying all formula and thus table matches the first table of first image but as soon as i made summary changes all value i get are wrong when i choose for the All products in page selector . The data i get is *
-
level2 3.3.5.2 Confirmed PO Delivery formulas
POST(PO Submitted, Shipping Time Weeks) worked in Confirmed PO Delivery Formula.OFFSET(PO Submitted, Shipping Time Weeks, 0) is right according to the hint in the module but it is giving wrong results as adding value in the current and 2 weeks ago column not filling the value in after two weeks.added a screenshot. Plz…
-
Issue When Using List Subset Picklist with a LISS
Hello, I've come across a scenario that appears to be a bug when combining Line Item Subsets and List Subsets. The scenario is that I have a report module that I created a LISS of. I then created an input module dimensioned by that LISS with a Line Item formatted by a list subset. The list subset is to only allow users to…
-
Error in formula for override forecast and final forecast
-
ACTIVITY 2.4.7.1
Hi Team, I have applied the conditional formatting as well as the formular but i keep getting 0 in my Forcast CF line item. Please asist to point me in the right direction of what I am missing.
-
Need to breakback the value
Hi, I have a module with 5 products (A,B,C,D,E). all the products have some values with respect to 3 line items (X,Y,Z). Now i wanted to distribute the value of A in to the remaining products(B,C,D,E). with common percentage. Any idea how can i do it? Example here: A B C D E Before X 100 10 10 10 10 After X 0 35 35 35 35…
-
Number to boolean format help
Hi team, Looking for help- i have a column with number format which shows currency value ( total) which takes FX rates into account as well . e.g $2,000,000 and so on... now i want to use filters which will give me projects having valuation more than 1,00,000 i created a boolean filter and tried to change the format for…
-
Identify Duplicates
Hi friends, Hoping to get some help with a method to help me finish up a labor calculation module. I'm tasked with allocating costs to contractors differently dependent on if there are multiple contractors from the same "Vendor" and "Area". IF multiple contractors from same Vendor in an Area THEN divide Area cost evenly by…
-
Update a filter based on picklist
I have a Module 1 with 2 dimensions. List A and List B. I have a line item in the module formatted as numbered List C which the users can select. I have a SYS module for List C. I would like to create a boolean in my SYS module that gets checked for any member of the list that a user selects in module 1
-
[Part 1] Validating user input in Anaplan: Approaches and challenges
Pros/cons of common approaches Common approaches: Examples Error logic User experience Example 1: Simple error messages Example 2a & 2b: Nested IF statement Example 3: Concatenation of multiple error messages Example 4: Separate errors for each line item Wrap-up of Part 1: Summary of common (sub-optimal) approaches…
-
level 2 Activity 2.3.10 Growth Rate Formula error
I have applied right formula in Growth Rate% of DEM03 module.But the hierarchical aggregation is going on.Is it right or Can I make a change so that Hierarchical error will not take place. But when I changed summary setting of growth% from sum to none then only SKU products have entries and levels above it didn't .I think…
-
How to Find Max for Specific line item
I am trying to create a module with the following line items (dimensioned by products in pages and line items in rows, time does not apply). when a product is select from pages: Max slots - display max value across any month When - display the month that the 'Max' appears Width Factor% - user input Width Interval - display…