-
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
-
Help Replicating Excel Formula
Hi, We are trying to replicate the following set up and formulas from the below Excel snap shot into a Module. Currently the Module is set up where there are two list in the rows. In the Excel the formula for the Rollup is based on a calculation and we want to replicate that in Anaplan, but in Anaplan the Parent item…
-
Help with Profile formula adding up few line items
Hi all, I keep having the same error, when I tried to add up few line items with PROFILE calculation in it. I have created a module to calculate items of the balance sheet and multiplying them but % over a period of time. When I try to add all the items to get the total, I have an formula error as per the picture attached.…
-
Length of Service and Tenure
Hi, I'm currently having trouble figuring out the Length of Service List and Tenure columns in the SYS08 Sales Reps Details module. There is a Length of service module already built, but it is blank. So I am unsure what to base the population of this column on. Also, I built a Reps tenure range module to calculate the the…
-
MODELLING TIP! How To Convert Infinity, -Infinity, NaN to Zero Value
Loving this tip! It is so annoying when by default your data display Infinity or NaN! Check out this community article to see how to avoid it!
-
Need formula help to offset time period
Hi all, I am having some trouble determining how to combine certain time functions. I am trying to forecast sales with an associated start date and end date. The attached shows what I'm trying to accomplish. I've tried offset but I can't use that with a time period. Is there another way to offset a time period? Thanks!
-
Priority distribution
Hi All - Was hoping I could get some ideas/help on this problem that I'm trying to solve. I am trying to automate the output of the "allocation" line item shown below. I have a set amount that I need to distribute into various list items based on the priority shown. The max amount allocated is shown in the first column.…
-
Lookup considering the Month
Hello, I have a Price List named "Raw Materials Price", and I need to pull from "Component Cost Increase" module the % increase by Component, Plant and Period (Jan 2021), hoy can I consider the period in the lookup formula? Raw Material Price List: Formula: Component Cost Increase Module: Thanks, regards
-
Storing Forecasted date
Hi my model has 5 versions Rofc, Forecast. Budget, Simulator1, Simulator2.(list) Rofc contains data of actual month and future month (similar to native switchover). I am creating forecast between jun-sep every year using Rofc data of the current year and locking the forecast data of that year. Forecast can be created…
-
Multi Dimension Ranking
Hi, I have 2 modules, 1 has dimensions of TenantGroup, ReportPeriod and UserRole namely AgingperGroup. And the other module has TenantGroup and UserRole namely AgingGroupRanking. The latest module will take the data from the previous and lookup the CurrentPeriod parameter to get the exact data(of which data period) to be…
-
Mapping
Dear All, I have one use case in which I am confused to get the output. Below is the use case: I have almost 10 lists (A,B,C,D etc.) and each list have almost 4-5 list items (A1,A2,A3,etc.). Now the end user will have the access that he can select the list items from each list (single/multiple). Once user has selected few…
-
function
can someone elaborate when to use sum , lookup and select in easy to understand way. i have read it from anapedia but still struggling
-
Search Text in a String
Hello Community, I am looking for a function to find a character(s) within a string, similar to CONTAINS function. For example, I need to find the word Ananplan in the string "I love Anaplan". Is there a function for this? If yes it will be really helpful if you can share. Thank you, Yogesh