-
"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…
-
Error with line item is not recognized
I'm try to find medical cost for employee in EMP02 (Employee Expenses) drives by Role and Department where i have to reference to EMP03 (Employee Driver by Role) and SYS08 Employee details. In my formula I didn't query direct EMP03 source module into target module EMP02 is because in EMP02 I don't have Department and Role…
-
Median Calculation on Multiple Dimensions
Hello - has any one ever successfully been able to calculate the median off of multiple dimensions? I have a list of customer spend data at the customer level and would like to calculate the median by certain attributes of those customers. For example, I have 10 customers all who belong to different countries, and…
-
How to return the month/time period of other line itme
Hello, I have a module with two line items. This module has product list on pages and line items on rows. 'Max Slots' has a formula that returns the MAX value of a given product from another module. For the other line item 'when' I am trying to return the month or time period that the MAX value takes place. I am trying…
-
Major UX Page Release! VARIANCE ANALYSIS...directly in UX page!
Yes! You can now do ad-hoc variance analysis! I'm about to jump into this right now and test it out - this is a huge addition to the reporting and ad-hoc functionality. Take a look below to hear directly from the product team and check it out. Please comment if you like this - I am really excited about the options this…
-
Formula error while pulling data from one module to another
Hello, My goal is to get the 'total volume' of product being used for certain year by different cities. Below are the two data set which have been successfully mapped into Anaplan I want to pull data from DATA02 into REV02 to achieve my goal. SOURCE DATA02- (data SKU Volumes) TARGET: REV02- (data Volume Inputs) I tried…
-
Import Data applying DCA
Hi, When i import my data, my DCA is not working, how can i activate my DCA so the import would not allow to change the data. Thanks, Tom
-
Last Workday of the month
How would I create a Boolean line item that would select the last work day of the month? Thanks
-
Parent to Child Mapping
Hi, Is there a way to map a selection made at the parent level to all the children of the parent? Product Hierarchy: L1 Program, L2 SKU My final output report is at the L2 SKU level. The users take multiple snapshots of this report during planning cycle. At the end of the cycle they want to select a final snapshot for that…
-
Advise on building methodology
Hi, Im trying to build out in Anaplan a way to take all the totals of the first day of each month and then divide it by the totals of the whole month. This will give me a ratio that is needed to multiply by each dayified first day of the month. Thank you
-
LAG() Rent Increases without Time Scale
Hello, New Model Builder here! I'm working to enhance an older model that uses a hierarchical list as a Custom Time Scale (CTS Months). The list is used in lieu of a time scale for most modules, however one of the enhancements involves applying market rent increases to the next 'time period'. i.e. a 5% market rent increase…
-
Data type mismatch: format other than LIST or DATE being referenced as a relation
this is the formula IF Employed? THEN Salary *'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role,LOOKUP: 'SYS08 Employee Details'.Department] ELSE 0
-
12.4.4 Activity: Create Saved View for Profit & Loss Report
this is actual which should have 0 as given
-
How to lookup a value from a source with no time
Context * My Destination module has the following dimensions: (1) Employee ID (2) Line Items (3) Time * My Source module has the following dimensions: (1) Movement Code (2) Line Items* Employee ID is a line item (List) * Effective Date is a line item (Date) Goal * In the destination module, populate an employee's job level…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
my resultthe lesson result