-
Help on Formula
Hi, I need help on a easy Formula. I need to be able to take everything from previous day from one Line Item and put it into the current day for the other Line Item. I know I will be using the previous function, but kind of stuck on this. Please advise. Thank you
-
HELP
Hi! I was wondering if anyone would be willing to help me, I am in the accounting 270 class and I am a little stressed out and confused. Let me know! My email is mgb14@geneseo.edu Thank you!! Maira
-
Button to Add another / new dimension after creating the module
As a model builder it would be nice to have a button to add dimension to the module and also to the line item after one has created the module. At the moment we can add the dimension to the module through the applies to section of the blueprint. It would be nice to have a window of dimension screen that is shown when we…
-
Input at each level of Hierarchy get aggregated view
Hi I have Project 5 level of hierarchy list(P1,P2,P3,P4,P5) , Expense list ,versions, time as dimensions User can enter expenses for each expense list item at P3, P4, P5 levels Suppose At P4 level entered 20 At P5 level entered 10 but for P4 I should able to see 20 + 10 =30 Hope this is clear Please help me on this. Thanks…
-
Context Sensitive Selection of Parent in Forms
As a Model Builder an Planning user it would be great if the Parent Selector of a Form could be context sensitive. Forms are used to create new Elements in a numbered list which often need to be dynamically attached to a parent. E.g. I want to create a new position ins a cost center looking at a specific cost center.…
-
Search Selective Access List
It would be SUPER helpful if, when giving a user selective access in the user section, that you could search for the list item that you want to give the user instead of having to scroll through a long list to find the item. I know this can be avoided by doing an import, but if you don't know the exact name of the list item…
-
Models topology- visual version
The idea is to implement a visual model's topology map. The initial idea is to build it like the module map available in the model that shows all module dependencies, but for models. Currently there is a possibility to find information about ALM models that are synced with another on the revision list and on the source…
-
Introduce sequential lists (Array or Linked list)
As model builder I would like to make use of sequential lists (Array or Linked list) to avoid circular references. This can be useful in many calculations.. Native functions like PREVIOUS() or NEXT() could only be applied on line items which are on the time dimension. Such functions should then also work for the sequential…
-
Conditional Formatting for Swtiched Over Cells
Using Native Switchover functionality when the forecast data gets overriden by the Actuals can we have a color code functionality which will highlight Actual Data in Forecast version. As of now it is just editable vs not editable.
-
Dynamic cells?
Hi everyone, I have a grid where the user can tick to override an amount. If he ticks override, he can put the new amount below, else it is 0. The problem is that I want the user to be only able to change the amount in the line item "new average salary" if the box is ticked, and not to be able to change the amount if he…
-
Order List Action
Hi There id Order List action which is used to sort the list But we can sort if the module has only one dimension Is there any other way we can sort by using order list action if there are multiple dimensions like (2 lists or one list and time) Kindly give the solution Thanks Shirisha.
-
Copy Line Item
As a user, I want to have the ability to copy a selected line item while in blueprint mode. This functionality would save time and prevent potential user errors/toasts. I will know this is successful when I have the ability to copy an existing line item and type the name in a dialogue box that is brought up after pressing…
-
Ignore boolean flagged items/periods when using the AVERAGE function
Description: As a model builder, I would like to be able to include an additional parameter in the AVERAGE function which is to be used to exclude flagged items or periods from being included in the calculation of average values. Use Case: There are numerous circumstances where I have been required to exclude certain items…
-
Time Filter
Need advice best way to set up a Time Filter in my Daily Model that gives me only the Weekdays and not the Weekends. Please Advice. Thank you
-
What is difference between: ITEM & FINDITEM
EoM
-
Unable to infer employee-region relation given employees have accounts and accounts belong to region
Hello all, I am building a standard org. hierarchy consisting of employees, accounts and regions with the following rules: 1) Each account can be assigned with only 1 employee. 2) Each account belongs to only 1 region. 3) Each account for one employee is within one region. For some calculation purposes, I need to know, to…
-
Box and Whiskers Plot using Combination Charts
It would be a wonderful addition to the new UX, if the combination charts were allowed to be used with many different parameters which cater to many statistical methods such as box and whiskers plot which would allow to plot IQR (Inter Quartile Range), MAX and MIN of the entity as per traditional plot of Box and Whiskers.
-
Add a date stamp
HI All, II need to add a state stamp into a table. My plan is to have a Line item that somehow calculated the current time (equivalent in excel would be NOW()). I then plan to use the Import data to import that date into a static date line item in the same module. Does anyone know how to get Anaplan to show the current…
-
take a value from another module
I have a module named AAA like this: lowerupperPayout ratetotal invoicestatustranche 105000%$ 8500tranche 25009002.5%$ 8501tranche 390012003.0%$ 8500tranche 4120015003.5%$ 8500 And another module named BBB: QuantityValues $Rate Appliedproduct 148000$ 250?product 2 $ 210?product 3 $ 200?product 4 $ 190?TOTAL $ 850 I want to…
-
Decreasing the length of your formulas
All too often, when analyzing a model, we see very long, convoluted, and complex formulas. These are commonly nested IF THEN ELSE statements and can be in excess of 5,000 characters. Line item subsets (LISS) can be used to shorten the length of the formula while making the solution more dynamic, scalable, maintainable—and…
-
Data from one module to another module
Hi 1st Module I have expense list(5) and key figures list(6) with boolean line item (Check) .For each expense will check different key figures Another module Dimensions - Index list , Time and Versions Expense List formatted line item Key figure list formatted line item So when I select particular expense from the drop…
-
Docusign mapping
Hi , I am trying to integrate docusign integration . I am struggling to map line items in template . I have a below module ,email is email format I want to send a template with line items (first name,last name ,a,b) to "email ids" (3rd line item) .I managed to send the template to email ids but not able to pick the other…
-
Filter for Module
Hi, Having a hard time setting up Filter in the Module. I have created a Line Item in My Systems Time Setting Module that Boolean checks when a day is a Weekday and not checked when a Weekend. I need to know how to pull this filter into my Module. It is not giving me the option to do so and Im not sure why. Thank you
-
Sub percentage allocation based on different attributes
Hi I have one module with dimensions of Index list(Numbered list), time,versions I have 4 line items 1st- cost center-list formatted 2nd-Planning-list formatted 3rd-Business Area-list formatted 4th-Percentage-Number formatted(%) so cost center1-Planning Account1-Business Area1-I will enter %(20%) cost center1-Planning…
-
Form adding L3 Cost Type # list item only to specific C3 Cost Centre # list item
Hi, I currently have a module dimensioned by 2 Numbered lists: * C3 Cost Centre # * L3 Cost Type # I want to present a module on the UX dimensioned by these two lists and a line item for the Amount. The thing is, I want to be able to add more L3 Cost Type # list items from a Form, and that should only be added to a…
-
Find the position of nth time a character appears in a sting
I want to pull the description details from the History log. I have calculated the number of commas before the Description column which is 3 but I am not able to find the position after the 3rd comma to extract the Description data for multiple rows. Row 1 - ID,Date/Time (UTC),User,Description,Security Change,Previous…
-
How can I set conditions (IF THEN ELSE) when the first argument of my IF statement is not BOOLEAN
Hi, Would like to know how can I set conditions (IF THEN ELSE) when the first argument of my IF statement is not BOOLEAN formatted. What I'm trying to do is put conditions on my Row's A+/A++...ect to determine what number (6,9,12..ect) they will fall under. I have a pic attached. Please advice. Thank you
-
Daily Rolling Forecast
Hi, I'm trying to set up in my Time Systems module a Daily Rolling Forecast, but having some trouble making it work. I have attached pics of what I have done. Please advice Thank you
-
Sum Error - Mismatch
Hi, I am attempting to bring in the sum of one line item from one module to the next and getting the error: Data type mismatch: format other than LIST or DATE being referenced as a relation Here is the formula that is failing: and the referenced module: Thanks!
-
Publish other actions to new UX
Hi Is there any possibility of creating delete or add row of a number list action(other actions in Anaplan) in New UX ? Thanks Tejaswini