Calculation Functions

Deafult Forecast Errors
i m trying for Default Forecast and also with Round formula..I m confused about the formula. Can somebody help for this ?? I got the Baseline Forecast and Growth Rate%
COLLECT() function issue
Hi Community, Please see attachment for the details of the issue. Any feedback is appreciated Regards,
Level 2 Sprint 3.3.5.5 Final Shipping Method and 3.4.3 Country Made in
No matter how hard I try I am not able to the right formula for Final Shipping Method, so far my formula is "IF NOT Override Shipping Method OR ISBLANK(Override Method) THEN Shipping Method... Another query is do I have to give a formula for Country Made In line item...if so can anyone give me a hint?! Thank you in Advance…
Level 2, 3.3.5.3
Under INV module the JAN 20 beginning inv is matching Week 4 Beginning INV. Shouldn't the Beginning inv for a month be the same as Week 1? I keyed in some forecast values in DEM03* module. WIll this affect my results in SPrint 3? Hope someone can answer my queries THanks THomas
Activity 6 model building exam
The formula for 'REP04 Employee Expense Summary'.Salary is invalid: Salary = 'EMP02 Employee Expenses'. Salary[Lookup: 'SYS08 Employee Details'. Region, Lookup:'SYS08 Employee Details'. Role] The name 'SYS08 Employee Details'. Region used in the LOOKUP clause is not recognized as a line item in the model this error i m…
Activity: Add Formulas to Margin Calculation Module
why my unit price growth % didn't change even adding 5% in price growth rate plz help
Lookup not working - dimension used for lookup doesn't match any dimension of the source
HI I have 2 line items in the same module which are both in list format using the same subset list. I would like 1 of the line items to be completed based on the entry made in the other. I have created a mapping module using the same subset list as for the module and the line item (see attached screen shots). But when I…
11.3.3 Activity: Add Profit & Loss Report Module
Hello All, When I put this formula, IF 'SYS09 Version Details'.Forecast? THEN 'OTH01 Non Employee Expenses'.Shipping Costs ELSE 'DATA01 P&L Actual and Budget'.Shipping Costs I am getting this error The formula for 'REP03 Profit & Loss Report'.Shipping Costs is invalid: Shipping Costs = IF 'SYS09 Version Details'.Forecast?…
number of months left in the model calendar
Hi, I'm looking for a way to reference the last month in the model calendar. For Example My model Calendar is 1 previous year and 2 future years. Currently the last Period is June 2022 however when the model calendar increases i want the formula to reference the new end period. I then want to count the months from the…
about sum functon **** we can get the data last from 6 months actuals?
i have actuals data from last 6 months ..i have created last 6 months line item to get the data here .. Then how can i write the formula here .. Example Jan Feb Mar Apr May Jun July Aug Sep Actuals 100 200 300 400 500 600 700 800 900 last 6 months 0 0 0 0 0 0 0 0 0 Present my module is like above format so i need last 6…
Dynamic Native Version Selection in Export Module
HI, I have a staging Module, version dimensioned where I collect the data I need to export. In the export module, I would like to remove the Native Versions and make the versions selection dynamic. So that the Line Item – Amount collection would collect the amount from a selected version. Version Selection module (below…
2.4.7.1 Conditional Formatting
I do not understand why my module does not match with the 'Check your work' module. Could anyone please help me out...
About formula
Hi i am trying to write the formulas about Actual/ Forecast here i have actuals data and forecast data and current month selection i am trying to write here IF ITEM(MONTH) < = Current month Then Actuals else Forecast here i havve everything like I HAVE MONTH LIST AND CURRENT MONTH MODULE Actuals data and Forecast data..…
Unique Project Names
I allow users to create a project which gets tagged to a numbered list (Projects), Users are expected to give a name, is there a way I can let the user know that the name already exists ? I have brought a logic to check that but its somehow not capturing Capital letters For example, if project is named 'Jack' and if user…
Level 3 Sprint 2 Problem of Quota of Sales Reps and Assignments (User Story 3.2)
Hi, Misbah For calculating the Target of Sales Rep, I created a Line Item Sales Rep in TAR02 Account Review and created a formula of Target applying to Sales Reps Flat# in QUO07 to obtain the Target of every Sales Rep, but I received a message, but the result is not good. The Target showed Total of all Sales Reps and…
Calculate First/Last Week
I want to calculate First/Last Week Like this picture. I set the "General Week" as Time Setting. I have no idea to do it.
Stop Summary in the middle of Hierarchy List
I have this type of List. ALLRegionCountryWorldEuropeFrance German AsiaChina Japan I want to Sum Lineitem by only Region not All, Like this Table. ListLineitem(None)Lineitem(Sum)IdealWorld 40Europe 22France111German111Asia 22China111Japan111 By calculating this table, I can filter Country List by Ideal Lineitem. How can I…
Percent calculation
Hi, I'm trying to calculate the following: if field a< 20% of field b then 1 else 0 How do I approach this? Please help. Thanks
Module data transfer from time scale to different time range
Hello Everyone, I have two modules as mentioned below.I need to get data from module1 Jan20 to module2 Jan21 and same follows for other months. Module1 Time Scale -FY20(jan to Dem) Line item - Data Module2 Time Range -FY21(jan to dec) line item-data1 Can someone help me with this. Thanks Tejaswini
line item total in another column
Hello guys, pretty sure the solution must be simple but i cannot find it. I am trying to use the total of a line item in another formula. what i have looks like the screenshot Thanks in advance 🙂
Movingsum
Hi, For your assistance please. I am trying to aggregate specific invoices and tried using the movingsum but on the last invoice cut off 4 which the number of days are variable. How can I count and use the movingsum? or is there another formula I can use? Example : August 2021 Invoice cut off 1 - starting 1st of the month…
Fake Week and Sum with Month
Hi, want to SUM value with Month. I set the time setting as "Week General". It has no month aggregation, so I made the Month List. And I calculated month value as a described below. <Solution1> Formula: TimeSum(Weekvalue, start, end) ＋value(adj)[Lookup:start-1] - value(adj)[Lookup:end] week(start/end) start end weekw6/28…
Real time inventory model
Hello Anaplan Community, I am attempting at building a real time inventory model that has kafka and postgreSQL integrated with Anaplan and has a base code in Java. I was wondering if anyone else in the community has an experience with similar techniques and would want to collaborate or offer any advice. I was also trying…
TIMESUM syntax error
Hi everyone ! I am currently doing the Level 2 Model Builder, Sprint 1, and I am stuck at step 1.5.7 Basically, I need to feed a boolean Line Item called "Has Data?", which is on the SKU ; Account dimensions from a numeric Line Item called Volumes, which is on SKU ; Account ; FY19 dimension. Therefore, I need to aggregate…
SUM with Week general value.
We're using "Week General" as Time Setting. Week General has day and week value, but does not have Month Value. So I made Month List(Jun21-Dec21), and I want to aggregate the value from day to month. I used "Timesum" function, and could aggregate it week to month. Formula：Timesum(Lineitem, Startweek, Endweek) But I could…
Lengthb / LENB function
I would like to request a function to get the length of multibyte string in Anaplan. In some countries such as Japan and China, users can use multi-byte characters to enter number and alphabets. Our user wants to avoid entering the list name (i.g. Customer Name) in multi-bytes by mistake. Currently, end users can set same…
Multiple Items Identified as First Occurrence
We have a module dimensioned by Time and Item ID. One of the Line-Items in the module is Item Category. We need to identify the unique categories. ISFIRSTOCCURRENCE seemed to be the answer but it is identifying each category as being the first occurrence multiple times, once for each period. How can we identify the unique…
Level 3 Model Building Sprint 3 User Story 1.2
Hello, I am sure, this is very basic doubt, but i am not able to solve it. In 3.2 section, where we have already imported Baseline Financial Forecast from Excel sheet, now we are supposed to enter Stretch Goal/ Percentage increase for country's. My problem is, i am not sure how to enter time in one go. When i am going on…
Time summary setting for a line item with "Formula" summary setting.
Hi All, I am currently working on a requirement to cumulate the value of a line item. For this line item I have opted for the Summary method - "Formula" but I dont want the overall total sum for this column; I tried to change the "Time summary" for this line item , but it is throwing me error - Invalid combination of…
L2 Sprint 1: 1.5.3.1 Create Filter and Saved View for DAT01 Module - Issues with Filters
Hi, Im having some issues with activity 1.5.31 creating the filter for DAT01 Module, when I set the filter in place to show only values different than 0, i cant find the button to confirm the transaction and apply the filter. Can anybody help? Below snapshot. Thanks

Calculation Functions

Discussion List