-
Current page Context for page filters
I have a module with a list-1 in rows list-2 in columns list-3 in pages list-4 in pages. The dropdown for list-4 is dependent on item selection from list-3 and vice versa. Filters are created for that but when applied, I couldn't see the option of Current context. Alternative work around could be creating hierarchical…
-
Way to limit or not allow user to select a specific time period in the dropdown
Hi, I have a line item Start and End that has a list of 1-5 as shown on the screenshot below. In the example below for item 1, I have selected start and end date of Jan 19- Mar 19, in item 2 I have selected Apr 19 - Jun 19. Is there a way to limit the dropdown of the second item so that it will not allow me to select a…
-
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…