Calculation Functions

Accessing Data in other module
Hi, I have 2 modules say A and B Module A has id, name, key, value, key2_value For example: id name key value key2_value 1 x k1 v1 row_numidnamekeyvaluekey2_value1 1 xk1 v11 21xk2v12v1231xk3v13 42yk1 v21 52yk2v22v2262yk3v23 The formula for key2_value is IF key = "k2" THEN value ELSE BLANK Module B has name as rows and line…
Monthvalue in Anapedia
Hi I'm confused by the guidance in Anapedia on Monthvalue and Yearvalue functions whilst doing the Level 2 Model building. Having been advised to use these as part of the training to result in a boolean (which works) I was baffled by the Anapedia guidance that states it must result in a number. Is it a platform change…
How to post a Month from current year to previous year
Hi, I have a scenario where I have to post a line item which is month formatted from current year and post it in previous year . Module is by Year dimension . for example - I select FY 20 as dimension Line item -entry is jan 19 , Result - Want to post jan 19 in Jan 19 (though I input in FY 20 as dimension) Post /lag works…
SUM of a Line Item
Hi all, I am trying to calculate the total of a Line Item to use in a formula (for example: totals are listed at top or bottom but I need to use this total amount in a formula). I have tried to use a 'SUM' formula for the line item but have not been able to get the formula to correctly work. Is there a simplified way to do…
Calculation Month Mapping MODULE change???
Hello. Dear Anaplan Community. Anybody who can help with the Calculation Month Mapping? I got a task to change the calendar matrix and do some changes. In particular month, I have to delete the final run and move it to somewhere else. Or change the final run to 3rd run. If anybody is familiar with this module setting,…
Parent to Child Lookup/Selection
Hoping someone can help me with this one. The target line items are Split 1, Split 2, and Split 3. The target module is named 'Sales Pursuits' and is dimensioned by a list named 'Pursuits.' The source line item is 'Split Rank'. The source module is named 'Pursuit Team Split' and is dimensioned by 'Team Members' which has…
Have DCA drive when items are included in SUM formula
During our Territory Assignment exercise, the type of account dictates whether a particular rep type can be assigned to the account. We facilitate this via DCA. However, because the account types are sometimes in flux during the assignment process, a rep could be assigned to an account that they would later be ineligible…
Level 1 Model Building - Lesson 9.2.5 (Add fomulas to price growth rates)
Good Day Attached I have tried adding the 'LOOKUP' formula to REV05 Price Growth Rates Staging Module. However it gives me the attached ERROR MESSAGE. I have checked the dimensions however the mapping doesn't match any dimension of the result. Can anyone please assist? thanks
Line item - drop down list
Hi, For your assistance please. I want to add a "Description" in the column to identify the particular input item and will show as a dropdown list (description, example #1 - consumable item ). At first, I added in the line item but it should be in the column. Is this possible? Thank you.
Restrict User Input in a Field to a certain range
Hi I want to get user input in a certain line item related to number format but want to restrict the user input between 0 and 100. If the value input is between 0 to 100 then this value must be used as it is. But if the user input is <0 or >100 then it should return an error or must convert the value directly to the limit.…
Level 1 training program Anaplan model builder | Level 2 training program Anaplan model builder
Hello guys. how long does it take to complete the Level 1 training program Anaplan model builder? how long does it take to compete the Level 2 training program Anaplan model builder? it seems a lot of learning material. what is the best practice; (only to fly above as fast as possible)? or take a note of everything that is…
Need Help on Line Item Formula Total Beginning Inventory
Hi, Need help with Formula. I have the following below. Please advice. 'INV01 Inventory Ordering'.Beginning Inventory[LOOKUP:'SYS07 Distribution Center Details'.Region] Thank you
line item formula Stock Expectations
Hi, need guidance with the following formula. 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS04 Product Details'.Product Family, SUM:'SYS07 Distribution Center Details'.Country] Thank you
Stock Expectation Line Item
Hi, Confused with this formula. I have the following below. Please advice. 'SYS07 Distribution Center Details'.Country[SUM:'SYS04 Product Details'.Product Family] Thank you
Timestamp - Current Time (Formula)
Hi there, I realise this is not something new or possibly already somethere out there ... but wanted to raise it (possibly again) to show how important that would be. There are instances that multiple users are using the system. Sometimes there is a case that those same users use exactly the same processes/actions. Given…
Check Which Range a Value Falls in, and Return an Appropriate Value
Hello, For each list member in SYS78 (screenshot 1; "Rows") there is a corresponding Baseline value. I want to have the system compare the Baseline value for each list member to the Minimum and Maximum values in SYS77 (screenshot 2), and depending on which range it falls within I want to pull the appropriate Factor. So,…
Referencing Switchover Period
Is there any way in a formula to reference the Switchover period for a version? The module is pulling in data from a list across the time periods but if the cell is for a time period prior to the Switchover period, I want it to show zero, else pull data from the list. Thanks
Line Item Formula for Stock Expectations
Hi, I used the following formula and it says the dimensions do not match. 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS07 Distribution Center Details'.Country] After that I used the the following formula to have the dimension of P2, and still not correct 'INV01 Inventory Ordering'.Safety Stock Exception…
Inventory reservation with FIFO
Hi experts, I’m now struggling inventory allocation with FIFO algorithm. The requirement is automatic inventory reservation with SKU lot level expiration date as below. Automatic shipment allocation/reservation based on lot # orders using FIFO algorithm is needed. I’m trying a lot of ways using numbered list and many…
Formula to count the unique values in a column
Hi In the attached screen shot of my dashboard,I want to count the number of unique values in the Item column and display the count value near the title 'Comp Reservation Details'.Any help for the formula/workaround is appreciated. Thanks Regards Prabakaran
LOOKUP MAPPING
Hi, For your assistance please. I created system mapping module for custom versions (List: Actual, Budget and Reforecast). Scenario: I want to get the quantity difference of actual vs budget, in my Target module and I also included the custom verions in my applies to. I tried to lookup, apparently the values that I am…
Picklist using System module instead of List
Hi, Is there a way I can use a system module as my driver in the picklist ? Apologies, I can't find any related topics on this, please share if there are any. Thanks in advance. Tom
DigitalCPX 2020: Expert Advice: Model Cleanliness with Rob Marshall
It’s not too late for Spring cleaning! In this session, review and follow guidelines to effectively clean-up your model and optimize it as you build. https://www.youtube.com/watch?v=Vdrzgsbd3no We will focus on three key concepts: * Performance * Scalability * Maintenance Don't miss the Best Practice article and Guide to…
how to get a value of last week in a quarter
please help. we have scenario to get the value of a numbered field of last week in a quarter. For example we are in Q 1, we want the value of week 13 (which is last week in first quarter). do we have any functions available to get the value?
L1MB - rep02
I'm having trouble with level 8 Rep02 I'm getting the following error: Data type mismatch: format other than LIST or DATE being referenced as a relation I hope you can see my screen print with the other modules referenced
Auto Order Lists and API Enhancements - Help!
Anyone know where I can get the instructions on 9/26 release notes to automatically reorder lists and what the API enhancements are? Looks like some game changer upgrades! https://community.anaplan.com/t5/Releases/What-s-New-September-26-2020/ba-p/85429 Tag: @Misbah @DavidSmith @rob_marshall @LipChean_Soh @ChrisAHeathcote
Rank and Sort List with Child Items
We have a list within our Data Hub that needs to be sorted in a very specific order. We import this list into several spoke models on a recurring basis and in the past we've had to manually reorder the lists in every spoke model when new items are added (because new items are always added at the bottom of the list). To…
How to calculate within specific tenure?
Dear All, I am looking for the best solution how calculate/distribute an amount within specific tenure once it was triggered by a variable. Example: 1 million of revenue will be recognized equally over 24 months once the project is completed. The 1st month of the recognition starts on the following month once the project…
Year to Date Cumulation
Is there a function where I can cumulate an amount but reset it to zero when January is reached in the next year (we are using a 2 year timescale)?
Line Item Shipping Cost INV01
Hi, I need guidance on writing the Formula for this Line Item. My formula is below. 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP:'SYS04 Product Details'.Size, LOOKUP:Shipping Method} Thank You

Calculation Functions

Discussion List