-
Level 1 Activity 9.2.6 add formula to Margin calculation Module- Cost of Sales
Hi I am on learning level 1 activity 9.2.6 of Anaplan. I am struggling to insert the right formula for cost of sales formula as per training module is : Cost of Sales'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Cost * (1 + Unit Cost Growth %) All the other formulas are working well. I also tried to write the…
-
Conditional Formatting rule Inputted by user
Hi Guys, I just want to ask something. Now in the conditional formatting screen we have the range of MIN MID and MAX right as the basis for the color of the cells in Anaplan. Is there a way where the user will be the one to input the threshold (is the term we use in the model) or the MIN MID and MAX. in my example below I…
-
Can you pull line items into a modual from USERS list, fore example First Name, Model Role?
I am trying to set up some dynamic access within a model using read / write access drivers within certain moduales. I plan to do this by setting up a modual to set the access at user level using the user list as one of planning keys, but would be good if could pull in the assigned Roles, first and last name as would mean i…
-
Summing a line item based on time period in another line item
I'm attempting to come up with a total amount per period. However, the module I'm working with is not dimensioned. I have a month formatted line item called 'Period' and am hoping to sum up the 'Amount (LC)' line items that correspond with each Period entered. For instance, I'd like to see a total sum of the individual…
-
Different Time Scale problem
hi! I want to display the values from a module with a Time Scale of Half Year to a module with a Time Scale of Month. Can i do it? Please help me.
-
Circular References
Hi All, This is a pretty usual issue that I have seen others encounter as well but wanted to check if you have an elegant way of making it work. I am trying to calculate the available inventory at hand on a particular day using the closing stock on the previous day. So Day 1 would pick closing stock of Day 0 and calculate…
-
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…