-
Extracting text field from transactional data load module
I have a question regarding pulling a text-formatted field (e.g., a status entry that could be but currently is not list-formatted) from a large transactional data load module that consists of CSV-imported line items and then various data mappings to lists, numbers, etc. and some RANK and MAX cleverness to focus in on the…
-
how to capture last updated date of a record in anaplan as a value in a field
I have a module and it has three fields called A, B,C.. how to capture last updated date for those fields in anaplan. i know by clicking the history at the field level. but i want to capture via fields for those three fields. please suggest.
-
substitute function
i have list with codes in a test module I am trying to replace last digits of code by +1 using substitute function but i am getting result- A1B1_1 ->A2B2_2 ----incorrect A1B1_2 ->A1B1_3 ------correct A1B1_3 ->A1B1_4------correct A1B2_1 ->A2B2_2 -----incorrect A1B2_2 ->A1B3_3 -----incorrect A1B2_3 ->A1B2_4------correct…
-
Level 2 Sprint 1 SYS07 mapping
I am importing the Locations flat list into SYS07. Everything is mapping correctly except for Region. I deleted and then re-imported the Locations flat file, but I still can't figure out why I am getting this error.
-
Line Item:Confirmed PO Delivery Sprint 3
Hi, Would like to know if this is the correct formula for the Line Item:Confirmed PO Delivery in Module INV01. If not please give me some guidance. OFFSET('PO(Purchase Order) Submitted', Shipping Time Weeks, 0) or should I use POST(PO Submitted, Shipping Time Weeks) Thank you
-
Q4 Cert question.
Got Struck at Q4 in Cert exam. This is my selection in SYS08 so I am expecting Department value I am passing to Emp02 Employee Expenses module Here medical cost showing 36800 that is showing as wrong answer. Am I missing some thing here. Hep Appreciate.
-
Transform data in existing output module
Dear Community, I have a case where I need to transform data based on product and customer information. The basic concept is that I have certain product # 1 and that value should be changed for certain customers. I have started to investigate if I could have a system module where I specify that product and customers for…
-
Level 1 Exam Model
Hi, I was working on the level1 exam, my connectivity got lost.. Now i couldn't find my exam model Is there a way i can get it back
-
reading property as line item in module
What is wrong in this formula. Here I am trying to read property of Company code in this module.
-
Level 2 - Sprint 2 : Update Historic Volumes
Hello, I am stuck at step:2.3.9.2 Update Historic Volumes for Baseline Forecast I can't deduce the formula for "Offset Volumes for 1st Forecast Year" because I don't know the formula of "1st Forecast Year?" Would you please know the formula for "1st Forecast Year?" Could you help me please Thank you
-
Line items and item properties
Hi I have a question here can line item fields be populated with item property values by selecting item member in a module?
-
How to get Current Fiscal Year from Time, as a number, when Current Period is not set in the model
Hi, can I get help in how to derive Current Fiscal Year, set in Time, as a number when Current Period is not set in the model? I see how to get year if Current Period is set with year(currentperiodstart()), but what to do when it's not used? We currently have a line item in a Time Filter module that requires the year to be…
-
How to distribute the value of line item equally.
Hi, I have 2 line items where in one is Boolean and other is numeric(percentage format). if the Boolean item is checked for that property then the value has to be zero for that particular property and its value to be equally distributed to the other properties. for ex: In the screenshot the %alloc of the property 1 is 10%…
-
EMP02 Expenses are 0 after a certain date in my model
I am trying to figure out why my expenses stop in Sept 2020. I have reloaded my data to EMP03 three times. I have been trying to figure out what is wrong and I don't know what else to look at. Any suggestions?
-
Date formula: Month +3, Day -1
Hello Team, I am trying to write a formula that takes an inputted date and outputs a M+3, D-1 formula. The very tricky part is input for 1st of month should then be M+2 / D is last day of the month Examples: * Input 6/5 -> output 9/4 * Input 5/25, -> output 8/24 * Input 3/31 -> output 6/30 * Input 1/1 -> output 3/31 *…
-
Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.
Hi, While adding formulas to the line items in EMP02 Employee Expenses we were asked to enter the below mentioned formula BonusIF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0 but it's throwing an error "Dimension of…
-
Alternative hierarchies - Numbered List Required?
Dear All, Do I need to use numbered list for the lowest level of the Alternative hierarchies? I read through couple of examples and training, which all use numbered list. I was wonder if this is necessary. Thanks, Lily
-
IRR & NPV Calculations with Initial/Start Date
Hi All, I have tried a workaround for IRR, NPV calculations with initial Date i.e. similar to excel in Anaplan. It worked for me and Hoping that it will be helpful for others too I hope below Screenshots are in-detail to understand the logic.
-
Drop-down list showing only Write-access list members
My client uses the Organization structure as the secured dimension in the model I am working in (Business Unit / Cost Pool / Cost Center) with Business Unit secured. They have multiple modules (pre-existing model in which I am making major modifications) that contain these lists as line items but are NOT used as a…
-
Profit & Loss Report Module - Getting Error on Revenue line item
Hi Team, I am getting below error when i am trying to update Revenue line item rule in Lesson 11. Kindly help me to find out proper rule here and suggestion. To my knowledge this error is coming due to additional dimension in source which is not part of target dimension. (Product) Thanks and Regards Akshay Sawant
-
calculation
Hi experts, I have three modules below: I wanted to get a subtotal of product1 based on the selected GRP2 & GRP9 product groups in the target module. I tried to use LOOKUP, SUM, and SELECT, I received an error. Please advise me on this case. Regards,
-
Foratting
Hi, I'm trying to create a Module that has the List of Days of the week as the Rows. I will have to use theses rows over and over again like the Excel Model, but will only allow me to have them once and the days of the week have to share the same formula. How can I format this so I can have it set up like I have it in…
-
help with formula
Hi, I'm trying to create a function that divides two line items, but the second line item needs to be the value of the 8th month from the first line item. This is the function that I created. 'F01 Funding Breakdown'.Total Funding / IF MONTH(START()) = 1 THEN OFFSET('F01 Funding Breakdown'.Scaled New Originations, 8, 0)…
-
Level 1 11.3.4 - Formula Error
Hi - I have tried to look through the response of those who have had a similar error but I'm afraid I'm still not too sure how to fix this. Error: Invalid formula for 'REP03 Profit & Loss Report'.Revenue: Automatic sum of 'EMP02 Employee Expenses'.Headcount over Users hierarchy is not possible as Users does not have a…
-
9.2.5 Activity: Unit Price %
Hi, When I try to copy and paste this formula I get the below error and cannot seem to work this one out. The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid: Unit Price % = 'REV04 Price Growth Rates'.Unit Price%[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product…
-
Formula assist
Hi I have a module which has a section for a "reviewer" to select a boolean to mark as reviewed. Reviewers are limited to certain persons and certain products. Initially, I had just used the Employees List and created a subset for reviewers which worked fine. However, I now need only certain reviewers to certain products.…
-
Can Switchover be used on a Daily basis?
Is it possible to do Switch over on a daily basis versus a monthly basis?
-
safety stock flag count: sprint 3 level 2
Hi This is my formula for Safety stock flag count: 'INV01 Inventory Ordering'.safety stock exeption count[SUM: 'SYS08 SKU Details'.county made in] but for exam this is showing incorrect. even though data is coming right I don't understand where i am going. Please help me . @Misbah
-
Level 1 exam formulas to the Line items
I am trying to update the formulas but it shows error. What is wrong for this formula? The formula for 'REP04 Employee Expense Summary'.Salary is invalid: Salary = IF Employed? THEN 'SYS08 Employee Details'.Current Salary / 12 ELSE 0
-
Total Positions for multiple dimensions
Hi Can there be any other solutions to show total positions having two or multiple lists on rows? Currently total positions is working with one dimension on rows. Thanks Tejaswini