-
Sum by Parent
-
Ability to customize Dimensions for line item summaries
I would like the ability to customize the dimensions across which the automatic line item summary will apply. Currently, we can only specify Summary (for all selected dimensions) and Time Summary. This means that for multi-dimensional line items, if I need a summary over one dimension I am forced to summarize over all…
-
Cannot enter decimals starting with a dot via new UX forms
It seems that we cannot enter decimals without leading zeros (i.e .068) via forms. The field on the form is from a module with the same list and has the number format. When I open the module, I can enter the number as .068 in to the cell but cannot do it via the form because it is giving me an error saying "Not a valid…
-
Very urgent ---- Formula assistance needed
Module 1: I have a Transaction List and the Employees responsible for the Sales. Module 2: These are 3 types of Cars of different cities Commission percentage. Module 3: Now the challenge is I have to make a new module with Employee and Commission. But the data should be flowing from Module 1 by ‘Connect to Anaplan Model’.…
-
mapping of property
Hi, I have created a list with members : A,B,C. This has a property with values 1,2,3 respectively which is also a list. Now in my list with 1,2,3 members, I need to map the values A,B,C (list) so that 1=A, 2=B, 3=C as shown in screenshot below : Is there a formula to automatically link the Property in List 123, to List…
-
Filtering Import
This is my Original Module. Now I want to create a New Module which will have only Orange Data. But I can't use Lookup, as I have restrictions of Formula Linking. Only thing I can do is Import. Is there any way to do it? Need your support.
-
MBL2: Conclusion INV05 Shipping Export
Hello! I would appreciate some help with the 'calculate shipping costs by location' formula in the INV05 Shipping Export -module. It seems like basic LOOKUP-function, but I can't get it right. The problem seems to be here the different time scales when I use values of DAT02 Shipping Metrics -module (month vs year) and time…
-
Data Pulling into Target Module
Hi Friends, I can't populate directly from list but need to populate the values from Module 1. I was trying with LookUp but it throwing error mentioning 'List does not have a built-in top level'. Please help. I am learning on my own and none to ask assistance.
-
Month Formula
Hi Friends, I have a list of Fruits and the month that is sold. Now someone has entered the month in TEXT format 1,2,3,..., 11,12. I want it to be Jan, Feb, Mar,...,Nov, Dec. Writing IF-ELSE is a tedious one. I was trying it in that way. Can you please highlight some easy way.
-
Calculation
Thanks community friends for your kind help. I am stuck in a step. Need your suggestions. I don't want the percentage to add up but remain the same (ie 5%).
-
Calculation help
Dear Members, I need only these parent values. Which will be the easiest way to do it?
-
IF function without ELSE condition
I am looking at a calculation where I want to have C = IF A > 0 THEN B ELSE DO NOTHING... DO NOTHING needs to retain previous value on C.
-
Dynamic module for list in a hierarchy
I need help creating a list for the market. I was able to do this at the retailer level, but how do you do the same thing for the market. I need to be able to do this so that I have the code for the market.
-
Line breaks in free text fields
Please add the feature to enable line items and data with free text, with all characters including line feeds. Ctrl+Alt+Enter creates a line feed while entering the data, but it is lost when the data is referenced.
-
Dashboard filtering selective access
Kindly suggest how to restrict the view access in the dashboard of unauthorised one.
-
Textlist on multiple dimensions
Hey Experts! Hope ya'll are doing well with everything happening around:) So there is this requirement where we require to bring in a list of selections into one single cell. My immediate thought was using a text list function (as i think that is the only way around it even though it has performance issues). Basically in…
-
Calculations based on text
Hi, I have an issue regarding how to set up a formula to get a calculation to work. I have a mapping module, where you can enter how a specific calculation should be done, looking like below: DriverComponent_1Calc_1Component_2Calc_2Component_3Revenues# units sold*average price per unitBLANKBLANK The format of the line…
-
Locking row item/s from deletion for select few roles on the basis of another boolean formatted line
Hi , I need help in the below query, I have a boolean formatted line item in source module published on a dashboard. As soon as the Boolean flag is marked “True” by ‘Role A or Role B’, the expectation is for corresponding row item/s to get locked from deletion for all roles except Role A & B on all the dashboards(two)…
-
line item with no time dimension
Hi, I have a module with no time dimension.In this module I have a line item "Contract Amount". In another module that has time dimension, I also have a line item "Contract Amount". In Jan 2020, value of the contract amount is 100,000. In Feb 2020, value is 120,000.In Mar 2020, value is 130,000. It is now June 2020. The…
-
How to set default value for list item
Hi,everyone. Can I set a default value for a list? I have a list of calendars. For example, if the current date is February 1, 2020, I would like to display February 2020 in advance. Best regards. Taku.
-
Totals remove.
Hi Friends, Is it possible to remove the totals. I didn't select any top-level. I want to look it as below.
-
Anaplan equivalent of the "Product" Function
I would like to use a formula that calculates the product of a series of items.
-
SUM in conjunction with boolean filter
I have 2 modules: Data Module and Dashboard module. 1. Data Module has: Region (List Item) Product (Line Item with List Items called PRODS) Value (Line Item) Export? (Line Item - Boolean) e.g North America PRODS=Mountain Bike 100 True Europe PRODS=Mountain Bike 50 False I would like the Dashboard module to have:- Region…
-
Lead formula not allowed for formula summary
Hi, I have a line item in percentage (POC). I already created the formula and set the summary totals to formula to get the correct %. But I need the value of the percentage for the following year. for example my period is Jan 2020, I need to reflect the value of the percentage in Jan 2021 in my Jan 2020 period. I tried…
-
Calculate Week and Days in a Week: Not a straight forward logic
Hi All, Hope you are doing great! I have to create a peculiar way to calculate weeks and then calculate the days in each of these weeks. Please find below the rules to create a week- * Weeks will be defined from Sunday to Saturday. The only exception to this rule is stated in rule(4) * The usual number of days in a week…
-
Enter Formula
Hi, Curious to know if I enter the formula at the line item directly, would it work (screenshot)? Im doing LM1, reccommneded method is to double click and write on top or expand the formula bar. But looks like it is editable at the line item directly as well, but I am not sure if it will work..
-
CODE, PARENT AND 'GRANDPARENT' FUNCTION
Hi CODE(ITEM('G3 Location')) and PARENT(ITEM('G3 Location')) were defined for the following Code and Country results. Is there a 'grandparent' function that can be used to display Region?
-
Null value vs. True zero
Hi, I am trying to differentiate between a 'null' value versus an actual true zero (- vs 0) on a dashboard. Has anyone had any experience with this? I am looking at formula options to resolve this issue. Any help is appreciated! Thanks, Kaley
-
Previous year unitary calculations and summing
Hello everybody! I've come across a problem with making accurate calculations for a line item in currency/unit for previous year. My model has system version called "current" which has 5 years (2019-2023). Time options: months, quarter, ytd, FY. I'm making a module that is based on line item subset (included are: Volume in…
-
Error in List
This is the original list. This is my new List.