-
Based on version line items need to filter in DB
Module has line items and Versions toggled Q :If a module has 15 line items and a version dimension (A, B, and C), the user wants to filter based on the selected version in the DB: If Version A is selected, only line items 1 to 10 should be visible. If Version B is selected, only line items 10 to 15 should be visible. If…
-
Straight Line Depreciation spread issue
Dear Model Builders, As per attached screenshot of my Straight Line Depreciation code, I am not able to get depreciation to calculate and spread for all subsequent months from Date in Use to Useful Life of the asset. All I am getting is a depreciation for a month of Date in Use but not for subsequent months. I have even…
-
Summary Calculation for Hidden amounts (DCA)
Anaplanners, I have got a question: I have a module with the following setup:Dimensions: Scenarios, Category, Time (Month)Line Items: Operational Metrics (e.g., Maintenance Costs, Revenue Earned, etc.) Another Module: Controls whether specific months (e.g., April, May) should be marked as "Inactive". When months are marked…
-
Syncing Alternate Hierarchies on a Board
Hi, I am currently working for a model in which we have two different hierarchies, 1 is D1→D5 and other is P1→P5 where D1→D4 and P1→P4 are the same, and D5 and P5 are different. Now I am using two grids on a same Page, 1 having P1 hierarchy and the other having D1 hierarchy, because of this I am seeing to different Page…
-
Dependant dropdown in Polaris
Have you encountered the problem during building that the Dependent dropdown does not work in Polaris the way it does in Classis? I somehow see the Dependent dropdown Check greyed out for the lists I want it on. Am I missing anything here?
-
how to take average in anaplan ?
difference between average and time sum function ?
-
How to convert month to text?
I am needing to convert month to text as we have a specific nomenclature we use for our company (i.e, if the current month/pay period is May but the pay accrual month is April I am needing to have a text display for May 25 as AprilPayMay25). I've done a lookup table in the past but was hoping for a formula that could do…
-
workflow
workflow - in a group task of 50 people. each assignees (50 people) has complete task button on the task page. but it doesn't make wait to see all the 50 people hitting complete button, we want anyone out of the 50 assignees to hit the complete button to work for all and push the task to the next step
-
To show only limited list items in the dropdown while saving a scenario
We have a save scenario button on our UI, when the user clicks on this button, backend process is executed. The backend process runs a set of actions. For the backend process to be triggered, User needs to choose a scenario from the dropdown list so that all actions save against the chosen scenario. While presenting the…
-
Fixed Line Item vs Column Headers
HI all, I have a transaction list that I am trying to import that covers a teammates hours worked amount and the payment amount. I am trying to import it into a model dementionalized by things like Teammate ID, Location and the type of hours(i.e. Salary, PTO, etc). When I try to run the import using column headers to…
-
Workflow: Assign to users from a line item in a module, with multiple users
I have a module and it has a boolean to check for a missing field and if the field is missing I want to send a notification to multiple users, via a workflow. I have a field called 'Notify' set as 'users' list.(I can easily enter 1 user from dropdown.) However, I want to add multiple users to this field, so I can use it in…
-
Waterfall chart intermediate totals
Hello, Does anyone know why the waterfall intermediate total is showing up in blue? I'm using a ragged hierarchy. With intermediate totals turned on & colour set to black I want to see the forecast bar also as black. Is there anyway we can achieve the same? Thanks in advance!
-
Can I rename an Action used in Anaplan Connect
Hello, I have multiple actions used in Anaplan Connect that we would like to rename… Do you know if renaming has an impact on good operation of my API ? If so, do you have best practices to share ? Thank you !
-
How to get value from time dimensioned module to non-time?
Hello, I have a module DEM03.1 Mapping (CV&ADI) with Time dimension and LIST03 SKU with the same List but without time. I'd like to get first non blank value from Date of introduction Line Item in DEM03.1 (1 pic) to Date of Introducton in LIST03 SKU (Pic 2). How can I do it?
-
How to converte a Date to a text
Hello, I am trying to convert a date (Line Item "DLC DATE") to text (Line Item "DLC DATE TEXTE") using this formula: TEXT(DAY('DLC DATE 2'), "00") & "/" & TEXT(MONTH('DLC DATE 2'), "00") & "/" & TEXT(YEAR('DLC DATE 2'), "0000") However, I don't get the correct values for the month or day when the value is under 10. For…
-
I am currently self learning L1, on Anaplan and unable to set this prompt in a practice session.
Can someone please view this and help me how to set this in a right way? 7.2.3 Activity: Import Data into Employee Details Module In the model, open the SYS08 Employee Details module Download data file: Employees.csv(opens in a new tab) Preview of Employees.csv DO NOT open the .csv file in Excel before completing the…
-
L2 Model Building - Sprint 3 - confirmed PO delivery
I am stuck with building the formula for "confirmed PO delivery" In case line item "PO submitted" is 1 for week x, it should show 1 in line item "confirmed PO delivery" for week x + offset. The offset number is depending on the shipping time shown in week 1. I used formula: IF PO Submitted = 1 THEN OFFSET(PO Submitted,…
-
Question about Boolean line items
Scenario My rows include 3 items - REC1, REC2, and REC3 my columns include quarters - Q1FY25, Q2FY25, Q3FY25 and Q3FY25 Line item - 'Select' which is formatted as Boolean. Desired Output - If I check any one Boolean among REC1, REC2 and REC3 for a particular quarter, the remaining two rows should automatically be disabled.…
-
アプリ表でのフィルタを合計に反映
アプリ上での表でのフィルタを、合計に反映することはできますか？
-
Order in SUM agregation parameters for performance
Hi hive mind, I have a tricky question. Here we go : I have a target module with 3 custom dimension (A,B,C) + Time (Month) I have a source transaction module containing line Items with A, B, C list formarted and a date column and an amount column In my Target Module, I need to agregate the Source amount with A,B,C and…