-
Get Total Value on another Line Item
Hi, Please help how can I get the total value of another line item to the other. Pls see attached screenshot where I tried to use lookup of the parent hierarchy to get the total value but it is not picking the correct value. Thanks in advance, Tom
-
Search an item in Module in a specific range
* Module dimension: Department, Country * Line item: User Name. (Formatted with a fake User List) I'd like to get all unique User Names from a specific Department 'ABC' and ALL Countries, with these unique user names, I'll able to build a list. I tried to create a subsidiary view in the module, dimensioned with fake User…
-
Analogue of SELECT CASE function
This would allow to exclude nested IF-THEN-ELSE constructions.
-
Lookup Demo App
While seeing the Level 1 training, I came up with the LOOKUP demo app. But I couldn't locate it in the app hub. Where can I download it?
-
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…
-
Sort function missing "OK" button
Hello, I am trying to complete Activity 12.4.6 in Module 12 of Level 1 Model Building, but my sort function is missing the OK button to implement by sort. I've tried restarting my browser and computer, but no luck. Has anyone else run into this issue?
-
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
-
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
-
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…
-
Request Enhancement - reference the Year from the Current Fiscal Year set in Time
Request Enhancement - ability to reference the Year, as a number, from the Current Fiscal Year set in Time...similar to how we can refer to current period with currentperiodstart(). In our case, we don't use the Current Period parameter, so are not able to derive FY from it. Thanks, this would be really helpful and even a…
-
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%…
-
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 *…
-
Model Name as a Field in Blueprint view
Hello there, I had an idea, I believe this idea can open up a lot of possibilities as to how you can leverage the blueprint view for Model optimization and performance management. I see that the newly released Module Name field has opened up a lot of possibilities when analyzing my blueprint views. I am trying to build a…
-
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.
-
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,
-
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)…
-
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
-
Time Function in Anaplan
Hi Team, Need your help with the below requirement, We are using 5 line items with a date Format. Line ItemsEmployeeABCDEMahesh12-02-202101-01-202110-01-202112-12-202010-01-2021 Based on the available Dates, we want to find the earliest date through the formula. how we can achieve this Anaplan? In the above example, the…
-
Missing Data in Production Model
Hello, These line items are working properly on DEV Model. I can choose a value on drop down menu of the line item "DATE CREATION (MANDATORY)", and the data will populate in the other line items. However, in the Production Model there is no data. I can choose a value on "DATE CREATION (MANDATORY)", but the data will not…
-
Help with SUM
Hi Guys, I have a target module containing a dimension which I need to map into a line item. Taking the system module containing the source dimension I have created a line item subset containing the line item in the target and mapped the target line item to the source dimension. In addition to this I have a line item…
-
How to take the count of a text value that repeats
I have got a text field (column) say X, it has got values x1 x2 x2 x3 wanted to creat a new line item to take the count with same value, for eg: x2 count will be 2 since it has got two entries.
-
Circular Reference
I am creating a model. But when I input something on the line items, then there are errors "circular reference" popping up". Would you help?
-
TEXT() function to follow Excel rules
Being a Anaplan builder, I would like to extend TEXT() functionality to work similarly to excel function, exactly: 1) Follow different format conversions 2) Follow preset patterns, to exclude unexpected text from numbers results etc. Example of wrong work to be prevented with new functionality: Text(1504322.40)= 1504322.4…
-
Formula
@jasonblinn Thanks for your previous answer. I had one more question. Here I am use 2 modules, puling data from one modules to another with same line items by directly referring each line item. But I am not getting the values into target modules. From 1st snapshot I am trying to pull data into 2nd ss. Can you please help…
-
Need help formatting and writing this formula.
Hi, The Excel Version of the Formula I'm trying to write is =MIN(ROUND(ABS(((UI20+UJ9)-UJ40)/Collection_Funding!UI3),2),0.98) The Formula I'm trying to use is MIN(ROUND(ABS(((previouse(total eligible principle)+paydown)-Min Assesset Requirment)/Previouse(Collection Funding!RTR)), 2), 0.98), which I do not believe is 100%…
-
Average of Every Monday
Hi Team, I have to find Average of particular Column based on the DATE . (i.e.) * To find How many Subjects have been Enrolled in a Particular Site? * To find Average of subjects enrolled per week, we are calculating Every Monday(We used WEEKDAY function to get a first day of the week.) Can any one help me with this?…
-
Pull data into current year from previous year where both are list items
How do I pull data into current year from previous year where both are list items and both are used in a module?
-
How to get the nth occurrence of an item using the same list
Dear Community, Hope you can help me with this requirement, this is the scenario: there is a list of products and a dedicated module that allows the user to select the replacement product from the same list. A product can be replaced by one product only, while any product can replace multiple existing products. Referring…
-
FIRSTOCCURANCE should happen based on High number
Hi All, Is it possible to get FIRSTOCCURANCE based on Highest Number? As per the below Example: 1. "PRODUCT A" has the Highest Transaction number- 4,000 in the second Hierarchy(Bucket 2). "PRODUCT A" Will TRUE Under BUCKET 2 Parent. 2. "PRODUCT C" has the Highest Transaction number- 3,000 in the first Hierarchy(Bucket 1).…
-
Stagging List
Hi Team, Please help me with the below requirement, I am using two list items 1. Product List (Stagging List with Hierarchy) Ex: 2) Key Products(Flat List) Ex: Having only one Product: PRODUCT A In the Product Hierarchy list, I am maintaining one attribute called Key Product ? with the boolean format. Now, in Product…