-
transform data's timescale
if Module A is in weekly time scale, Module B is in yearly time scale. What formula should I use to pull a line item from Module B to module A? Thank you.
-
MBL2 Conclusion INV05 Formulae
Hi, I have spent a long time trying to figure out the formulas for the line items in the INV05 Shipping Export Module. For Shipping Costs - 'INV01 Inventory Ordering'.Final Shipping Costs and I know we need to also bring in the SKUs from one of SYS modules. However, I am unable to bring in the SKUs. Any help would be…
-
If I don't mark a list as Production List, what will happen? Since I don't modify my list often.
As I read, if I mark a list as Production List. I can make changes to it, even in Deployed mode. What type of changes? Properties, Subsets, Code?
-
Importing data Module-to Module
I’m trying to put Lookup and SUM function but every time it says ‘The formula is invalid’ and it doesn’t exactly tell what is the problem. I want to import data in Module F from Module A and Module B. I tried to use below formula for importing Module A data to Module F as they both have same dimension so i thought it would…
-
Computation with Price Escalation
Hi Guys, I would like to ask something regarding a formula I have been working on. See the table below. Price Escalation formula = Input Avg Selling Price = The Jan 13 value is constant referenced to 2.3 which is in another module. While the succeeding months starting Feb 13 to Mar 14 the formula is Avg Selling…
-
issue in anaplan level 2 training content. Help!
Guys I think there is a serious issue in the formula suggested for building "INV01 Inventory Ordering" module in this course. The requirement is to write a formula that would result in "Final Shipment Amount" to get reflected in the corresponding week as "delivered value" based on the "shipping time" of the "selected mode…
-
Formulas Text
I want to write Sweet for all taste. Please tell me, how can I do it?
-
Help Post ---- Import Parent Level data
Dear Friends, I am in urgent need, to find the Parent level total in a different module. But I am unable to do so. SUM, LOOKUP didn't work mentioning issues. Kindly help me, I am in really dire need.
-
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.
-
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…