-
CAN Property become list
can any let me know, can the property become subset of a list
-
Put total in a line item
Good afternoon, I would like to place the total value of line item '%' in line item 'A'. In other words, I would like the amount 17,259 to appear in all the fields, but I haven't been able to do it. Could you tell me the formula to achieve it?
-
combine two line items
I have two line items that are addressed to the same list but each one stores a value. that is, in lineitem1 there are some countries in lineitem2 there are countries that do not appear in lineitem1. I need to combine lineitem1 and lineitem 2 into lineitem3. How can this be done?
-
actual and forecast
Hi there, Anyone please help with the formula, Here i have actual value in one line item based on that the override line item should be editable. where jan22- apr-22 is actual values, show that override line item should be editable from may 22 Please suggest
-
No reference cell count
If Anaplan can provide the column for the total number of no reference cell count for each line item in module grid view, It will greatly help modelers to identify the line items which is having more sparse cells. Modelers can work on those line items to less the sparse cells. I believe it will help at the module level as…
-
Fake Time to Real Time Calculation
Dear All, I have one use case where I have created one template for input the data. For this I used fake time dimension because the data will enter at monthly level in Year 1 and for future it's on yearly. Screenshot one shows the template which used to enter. But I am stuck between creating summary report. Because for…
-
Multiplication and adding two different line items
Class 1 is starting from 7 mar and class 2 is from 21 mar Now i need to write formula in Total For example in 21 mar Column, 62 * 2 (which is week 3 * prod ) and 80 * 2 (which is Actual Start - Day 1 * Prod (Next Wave)) (62*2)+(80*2) = 284 ----- the formula in Total is not correct now I try averaging the Prod and Prod Next…
-
How to get a first value of line item
Hi, I have requirement where I need to identify the first value of Borrowing line item and that value would flow into initial commitment. So I have used ISFIRSTOCCURENCE with a logic IF Borrowing <> 0 THEN ISFIRSTOCCURRENCE(Borrowing, Revolver Facility) ELSE FALSE but this will giving me two occurrence. what I need is the…
-
I want to get the first month of a period set in module calender.
hi! I want to automatically display the first month of a calendar set in a module that has not been applied to. Can ido it？ Please help!
-
Actual vs Plan Reporting Issue (Different grains = double-counts)
Hi All, I have the following 3 Modules: Module 1 - Staging (Actuals) Lists - Supplier, Service Category, Time, Line Items (Amount) Module 2 - Input Plan Data Lists - Supplier, Service Category, Maintenance Category, Time, Line Items (Amount), Versions Module 3 - Reporting Module Lists - Supplier, Service Category,…
-
Formula Editor with AI suggestions
As a SA, when we perform the model review, one of the most common issues are badly written formula. MAT analysis does provide a list of potential issues. It would be nice to add another button in addition to apply as Suggest, so it can warn the users when they try to create complex formula. Even better, given the vast…
-
How to get previous value of line item which doesn't have time dimension
Hi, I have a use case where I'm using the custom time dimension list in which there is a line item called Beginning balance which is the previous value of the Ending Balance. So I'm stuck as there is not native time dimension being used in the module so I can't use previous function of Anaplan. Any work around is possible?…
-
There has to be a better way. Any ideas?
Hello, While on a rebuilding project with a client, I am ready to delete some modules. Problem is the line items in those modules are used in Formulas and are connected to downstream modules. I know I can reference the specific references in the Blueprint view, and scrolling over to see the Referenced By column. However,…
-
Increase 1 million list item limit for Order list action
Requesting to increase the limit of 1 million list item count for Order list action. Currently we will get the following error when list item is over 1 million: Cannot Run ActionThe number of items in the list (1000001) exceeds the maximum allowed (1000000)
-
Need to know why getting Circular Reference
Hi, I'm adding my "Inta Month Growth" LI to the formula I have in the "Less:Ineligibles" LI and getting a circular reference. I can not seem to find the root cause of the circular reference. Please advise. Thank you LI "intra Month Growth" Formula LI "Less Ineligibles" Formula The Circular Reference I receive when adding…
-
% Percentage
Hi Team, Wanted to confirm if the below screenshot is correct? In my module, calculations are working but why is it coming as 105% in the screenshot - Check your build Thanks
-
How to calculate the YoY growth in line item
I have Year wise numbers in my line item in a module, now i want to calculate the Year by year growth in between years. I want to calculate FY21 YoY = FY21 Productivity growth / Fy20 Productivity Growth. FY21 YoY= 2.55% Please suggest me how get the result.
-
Incoherent summary when period is quarters, year or even YTD
Hello, I'm really at the beginning of the journey of being Model Builder so I'm afraid that what I'm to ask you is really basic, but hope to find help and the learn more :) . The context of the issue is that the following line item is looking for the customers that have 0 revenue in the current month, and if is true, then…
-
Formula Help
Hi, Need help on creating a formula where it takes a input % for the month, and if a End User wants to change that % then they can and that % will run through the End of the Month. Having trouble making that daily input % run through for the rest of the month. Formula is below
-
Lookup Mapping
Hello Experts , I just Want To Take Data from (Increment by Product family) to (increment By product) For this I used Lookup Function ex Increment by Product family[lookup: Product family] formula apply successfully but did not get any value . can u help me Remember Product is the child of product family Thanks in advance
-
Another Question
Good Afternoon, I am yet getting another error... Data type mismatch: format other than LIST or DATE being referenced as a relation Anyone what this mean? Thanks Tony
-
Aggregate value of lineitem
Hi team, I need to aggregate of a line item-1 with number of accounts and display in another lineitem2 in same module. Line Item 1 - Total Sales Revenue by Account (Each product family has number of accounts under it) LineItem 2 Total Revenue by Country = SUM of account sales target of all the accounts coming under that…
-
How to use “SUM” function in Anaplan: Explanation Through an Example
Hello Anaplan Community, During my Level-I and Level-II trainings I thought that it would be useful if an explanation with an detailed simulation for use of LOOKUP and SUM functions. There for I prepared a detailed explanation for each functions. Below you can find the explanation with an detailed simulation for use of SUM…
-
Level 1 Activity 9.2.3 Revenue decimals ?
While double checking some of my summary and formulas, I noticed that in Rev03 Margin Calculations I have decimals in my totals. However, in the verification screenshot there are no decimals. I checked the formula for Revenue and it is set to Number>with No-decimals. I checked the formula for the References in the line…
-
How to find GCD of 3 numbers?
Hello Community, I have a condition, where I have to calculate the "Greatest Common Divisor(GCD/GCF)" of three numbers in Anaplan so that I can utilize that GCD value to find the ratio. In excel we have GCD function and directly we obtain the GCD value. So, is there any way we can do that in Anaplan. Thanks Puneeth HP
-
Convert a number to Date
Hello, I need to convert this number formatted line item to 04/11/2022. Best approach?
-
Need some help trouble shooting calculations?
Need some help in trouble shooting calculations? How can I get this formula to work? Where do I start? Our amazing Operational Excellence Group (OEG) team share their techniques and best practices for working out calculations and getting them working!…
-
Data type mismatch: format other than LIST or DATE being referenced as a relation Error
Hello, I'm trying to this formula for the bonus line item and I'm getting an error message. IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 Can I have some help on what is wrong? Thank you! .
-
I'd like to pull the value of a line item based off of the selection of another line item..
I'd like to pull the value of a line item based off of the selection of another line item in the same module. I have a LiSS Module called Category Planning. It has values in 3 line items. Depending on what is chosen in the Select Option Line item, I want to pull the respective value into another module. Category Select:…
-
REP02 values not displaying
I currently have a filter to show forecast months only