-
IFS function
One of the most powerful "recent" functions I've used in Excel is IFS(), where a single statement can replace multiple levels of IF THEN ELSE statements. From Microsoft's description: Generally, the syntax for the IFS function is: =IFS(Something is True1, Value if True1,Something is True2,Value if True2,Something is…
-
10.2.4 Activity: Import Data into Employee Drivers Module
Not sure why this is happening?
-
Get Min Date
Hi, I want to get min Date. I set Min as Summary. If any source item is blank, Summary shows blank. Is there any way to get min Date?
-
CURRENTPERIODEND() does not work
Hi everyone, I was having trouble when I start learning working on a module with switchover. I set the switchover on and set the month. It started okay, until I want to get the data from the beginning until the end of the period. I used CURRENTPERIODEND() function. But when I check out the output it turns out empty. I…
-
Calculation logic for different hierarchies
Hi In source module I am having Hierarchy list with 6 levels(L1,L2,L3,L4,L5,A) where A is lower level of hierarchy which is having some count line item. In target module I am having L5 as dimension with litem as Total Count. Scenario 1: Now we are moving A1, A2 from it's L5-1 to L5-2, where L4-1 is parent of L5-1 and L4-2…
-
Compare two lists, one of it being numbered list
Can someone advise me how to compare two lists, one of it being number list ?
-
How to create a boolean with Radio Button like properties?
Hi Everyone, I want to create a boolean line item in a module dimensioned by a list, which can only be true for one list item only at a time. Let's say, the list has 10 members and initially that boolean is false for every list item. User checks the boolean for list item 2 and then User checks the boolean for list item 5…
-
13.3.1 Activity: Create Margin Summary Page
I don't see the option to create an APP. I've administrator role though. Help me sort this out please?
-
10.2.2 Activity: Import Data into Non Employee Expenses Module
tHE TOTAL TAB VALUES WON'T SHOW?
-
Level 2 - Sprint 1- 1.5.3.1
1.5.3.1 Create Filter and Saved View for DAT01 Module In the Data Hub model, DAT01 Beginning Inventory module, apply a filter and create a saved view: * Module Name: DAT01 Beginning Inventory * Saved View Name: Export The filter needs to work on one axis, so pivot the module view: * Columns: Line Items * Rows: SKU Flat…
-
Level 2 - Sprint 1 - 1.5.6.2
Attached is the picture after the import. Can anyone let me know if its right.
-
NUX Filters/Context Selectors should Match Old UX and View Functionality
If a View made up of multiple dimensions has top-level summary items selected is published to the NUX, the same functionality where the view would essentially be "locked" is incorrectly represented in the NUX. Context selectors appear and a user is able to filter on elements they shouldn't have access to in narrowed view.…
-
[First Look] Tab Split View
Feature: Tab Split View Release Date: September 2022 Impact Assessment: Optional Change What is changing? A tab split screen (view) will now be available for both Workspace Administrators and End Users. This functionality is comparable to the undock feature in the classic experience. What are the benefits? With the tab…
-
On-demand event based triggers
Is there a recommended way to utilize "callbacks" or "webhooks" with Anaplan? I have a use case where Anaplan needs to update Salesforce in real-time via an event based trigger. Use case summary: End-user inputs data into a dashboard, then clicks a process button to "submit" the data to an export ready saved view. The…
-
Summing Values across dimensions
Hello - I have modules dimensionalized by an L3 hierarchy (Co/Dep/Sub) with the line items equaling Accounts that are "collected" through a LIS. Now I want to sum my values into an L4; which is just "L3" and "Account "strung together; but my formula of Sum - Lookup: the "L3" and "Account" attributes (Mapped to the L4) does…
-
Quarter value of forecast for the Qtr in which switchover occurs
What are the alternative workarounds for this? When getting data from a line item Forecast version for a Quarter in which switchover occurs during the quarter, the QUARTERVALUE or [Lookup: <quarter>] return a value that only includes the Actuals amount for the month before the switchover date. (see screenshot)
-
level 1 exam - model building activity 2
Question: In the Level 1 model, update the REV02 Volume Inputs Module to include a formula to pull data from the DATA02 SKU Volumes module When I enter the formula: 'DATA02 SKU Volumes'.Volumes , all my data in the REV02 Volume Inputs module erases and becomes zero. Also in the REV03 Margin Calculation Module. I have set…
-
Vidéo - Gagner en efficacité avec la "New Modelling Experience" (2min 30)
Bonjour, Notre "New Modelling Experience" existe depuis déjà quelques mois. Et avec les récentes fonctionnalités, je vous propose cette vidéo récapitulant l'ensemble des nouveautés et des astuces pour gagner du temps dans votre modélisation. https://www.youtube.com/watch?v=BBcLmQNeuRk Lien vidéo Bien évidemment cette…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hi everyone, it seems that I have made a mistake and I can't quite pin down where it is. Here is my table:
-
6.6.4 Activity: Add Formulas to Time Setting Module
I am not sure why the Current Period Start isn't showing?
-
Compounding Growth In Forecast Model
Afternoon, Composing a typical growth forecast. I am having an issue when my raw data ends. (FY23 is the last year). Then once I get into my forecast years, the lag function (and previous function) have nothing to pull from (zero value). LAG(Research Allocation Rate (Original), 1, 0) * (1+Growth Rate). So essentially for…
-
Informatica to run process
Hi all, I want to run an Anaplan process from Informatica. How can I do it? I do not know what to put as source in the mapping and then the fields mapping as I just want to trigger the process, there's nothing like a source or target here. Thanks
-
AND and OR logical operators
In our work we need to frequently use several layers of nested IF THEN ELSE statements. These could be greatly streamlined by introducing IF and OR logical operators to Anaplan. For example: IF A = 1 THEN IF B = 2 THEN TRUE ELSE 0 ELSE 0 could be replaced with IF AND(A = 1, B =2) THEN TRUE. In this context, these operators…
-
Apps or pages don't disappear when the underlying model isn't found
Essentially what the title says
-
Show / Hide Categories in NUX App based on user role
In my experience most Anaplan implementations focus around a main app where the most users do their work, and most roles are likely only focused on a handful of pages. But as-is they will be faced with the full list of categories of in their dropdown, even if they can't go there or do anything. I think it would be a major…
-
Rank list items based on multiple ranking levels
Hi Anaplan users, I am trying to rank PO values by cost center & cost element & period & vendor & PO value. See screenshot and blueprint view attached to follow my reasoning below: I first want to show all POs from the vendor with the highest PO value at vendor & cost center & cost element & period level. That is what I…
-
Sync only the clicked members in the insight grid in Worksheet Page NUX
Hi Everyone, I am facing a problem in NUX worksheet page. When I click a member in the worksheet, the insight grids syncs to the immediate parent level hierarchy and shows all the siblings of the clicked member but I only want to see the clicked member only or differentiate it from its sibling after clicking (like…
-
Hide certain list member in dropdown
Hi, Is there a way to restrict user access in certain list but they should still see the amount when being aggregated at total list. I need to restrict user to all modules so using the picklist would be little tricky as I need to update everything. Thanks in advance for helping. Tom
-
Module with Users List
I have a module with two dimensions, Users List and Line Items. Ideally, we would like two Boolean formatted line items (Single Sign-on and Workspace Administrator,). Is there a way to import / write a formula into the module that pulls the information from the users section under model settings? This could apply to model…
-
1.3.14.2 Create T3 Build Geographic Hierarchies Process
Level 2 training 1.3.14.2 Create T3 Build Geographic Hierarchies Process Create a new Process: * Process Name: T3 Build Geographic Hierarchies * Add Actions: T3.1, T3.2, and T3.3 Could I get some help to complete this task? Thanks in advance!