Hi, I am trying to use MROUND formula to round to the nearest 100. However, there is some inconsistency that I spotted. original number * multiplier = number to round Example 1: Example 2: Why are the…
I'm currently trying to add the formula for the Total row, and I'm wondering why the SUM and LOOKUP formulas I've tried are invalid or not working. Here are the formulas I've plugged in so far: 'OTH01…
Hi everyone, I am stuck on a formula. I have demands for 2021 and I need to calculate the demand forecast until 2030 by using the formula below Demand 2022= Demand 2021*Growth rate 2022 Demand 2023= D…
Hi everyone, I recently discovered something within Anaplan that has made my life a lot easier when uploading data. For reference, I work at a mid-size firm and we have data that comes from our accoun…
Hi Team, Can we have to different Ratio summary for both line items and time. it will be helpful in few scenarios where we have to calculate ratios have to be calculated differently for line items and…
Hi Team, I have couple of queries regarding the below snapshot * Both Q1 & Q2 has 91 days, however the quarter balance is different? Can anyone explain the difference? * Are we calculating values for …
Hi Team, Can anyone please help here to make the Commission calculated based upon the range defined in 1 system module? Second last column in 2nd module (besides commission) to be referred in above de…
Hi I have this formula that will add 1(digit) to the months following the current start month however I would like it to stop adding number after month 23. I can't figure out how to end the argument/f…
Hi Team, Can anyone explain me this calculation? This calculation amounts to 102% instead of 100% As per my understanding, it should be 31/90 = 34% 28/90 = 21% 31/90 = 34% Still, I'm short by 1%. Can …
Hi All, I have created a module with two list (Company list: A,B,C) and Fruit list (Apple, Orange, Pineapple) Let say company A and C are tier 1 and company B is tier 2 And then i have created another…
Hi All, Desperately need help here! Why only the one field is not returning the results? EMP02 - Formula & Results In my REP04 File Results and Formula
Hello community, I have to do a lot of controls (boolean) and base and theses controls give me a value based on its true or not. I do a lot of these technicals line items for : -Controlling element -C…
Hi All, I have created a module with a list 'Fruit" and a list with 3 list item "A, B and C" Afterward i have created the second module only include a line item and without and two list mentioned abov…
I am Trying to calculate Depreciation by straight line method. But I don't know which function to use. It would be very nice if you me best method for calculation of the same. Thank you in Advance
I am facing cumulate function issue for numbered list. If unique index number of numbered list are #1 and #3 , without #2 (deleted for some reason), cumulate function fails to cumulate for list item w…
How to pick List Item against the List Code? have a situation..... explained below 1. I have a list which looks like the below 2. Using this dimension, there is a mapping module also. 3. Now, there is…
Recently this changed so that when you use the native Compare functionality in Anaplan classic, it no longer shows the name of what you are comparing to, but shows as "undefined". Previously this woul…
Hi, I have identified the starting month to start the series through boolean and time period function. However, starting from that month till end i want to populate numbers in a series on every upcomi…
Hi All, I have a list which has Product as parent and SKU as list. I am trying to calculate the number of SKUs with demand > 0 for all periods. Right now, using this formula - If demand > 1 then 1 els…
Hi Guys, How to define the current time period for system with out using Current Period & Switch Over, isactualversion & Iscurrentversions. is there any possible way to get with formula. BY this formu…
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. C…
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. …
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 overri…
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 …
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 ye…
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 …
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…
