
Calculation Functions
Calculation Functions
Discussion List
- 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 …
- 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…
- 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…
- 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 ad…
- 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
- 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 Grow…
- 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 …
- 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 maki…
- 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 ap…
- 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
- 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 a…
- 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 prepa…
- 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 checke…
- 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 ha…
- Hello, I need to convert this number formatted line item to 04/11/2022. Best approach?
- 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…
- 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'.Departm…
- 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…
- I currently have a filter to show forecast months only
- Hello All...I input 5% on my F19 for REV 04 , then i receive 20% for my REV 05...what am I doing wrong?
- Hello, I believe I am running into an issue where some formulas are using the Divide logic and running into NaN when dividing by 0. Does anyone have any reccommendations when converting NaN to 0? The …
- Hello, I am running into issues with the "NaN" when running financial or misc. functions. This causes issues when attempting to aggregate to a parent level. My current solution is: IF ISBLANK(TEXT(***…
- Hello Gurus, I have this scenario. Module 1 has the following: Time dimension (Month) List A Line Items including a line item called ExpiryDate that is date formatted. Module 2 has the following dimen…
- Hello, do you consider enhancing the Order List Action functionality by making it accessible for the non-admin users? It would be really great the end user to be able to apply such an order whenever h…
- Hi all, I understand Previous() can't be used with a non-time dimension. I have a custom dimension with a natural concept of a previous item. (it's actually a 13 period calendar that is not based on w…
- I am getting an error in my Sprint 3 activity 3.3.5.1 Create Inventory Ordering Module.when i am writing the formula for confirmed Purchased order receipt i am getting circular reference. my formula =…
- Update the formulas to reference the driver data in the EMP03 Employee Driver by Role module. Formula I am using: IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Emp…
- Hi Anaplan community, I am facing a problem and need help. I created a line item (Active?) to define whether the employee is active or not. The formula that I used is: IF PERIOD('DAT04 Employee Data'.…
- I am having an issue where only 1 cell does not match how my model is supposed to look like. It seems like "Utilities" (and subsequent line items that use utilities as part of its formula) is the only…
- Hello! I am looking to create sequential numbering on employee numbered list within their respective cost centers but also looking to skip certain criteria such as TBHs. I am currently using RANK(1, A…