Hi guys, i need your help, im struggling with this, i will try to be as clear as possible . * i have this dashboard, column 2 is what i have now and column 3 i what im trying to achieve (i added the c…
Hi, I have a module with a list of products with different ages. I want an end user to be able to select whether from a list to show all products < 3 years, >= 3 years and >= 5 years. In my module, I …
As a model builder I want to be able to setup a Grid which will be updated dynamically every time after a user wants to reselect any line item published as Field or Grid which are used as filters, but…
Hi, I am am stuck with trying to figure out the Formula for 'INV04 Distribution Center Capacity'.'Percentage Full' Line item. I can't seem to understand what all to use in it since it says: Can anyone…
I have a numbered list with different pricings with different validity time periods (Date From - Date To) in months. E.g., Item A #1 Price = 1000, Date From = Jan 21, Date To = Jun 21 #2 Price = 2000,…
Hi All, I am trying to use SELECT to pull through the top level value so I can create a phasing profile to push a single value down a hierarchy. I thought this would be possible but I am getting an er…
Hi, I want to use Notification Function in UX. I want a function that Member can mail to Manager. There are a function can select recipients by module. So, I tried to use it and make this List and mod…
Hi, question please. How can I calculate the payment cut-off which is happening every week. I have created a system module, screenshot below. Scenarios of the payment cut-off. 1. first cut-off - day 1…
I want to Offset values from dynamic day value. I hope the "Amount A" is offset to "Amount B like table. But the result was 0. 1/11/21/31/41/5Amount A 100200300 OFFSET 102 Amount B100300200 Result 000…
The lack of summary for versions made me create this formula: I am trying to get a functionality to have a boolean checkbox which will be FALSE for all other versions, but the one I have selected for …
I was going through the PLANUAL and noticed this error. I think the formula is wrong. If majority items in a list are blank then it should be: * IF ISBLANK(Line Item) THEN BLANK ELSE FINDITEM(List, li…
Hi, For your assistance please. How can I mimic the calendar in anaplan? my time period is Days but I need to get the specific weekdays equivalent (Monday to Sunday). I created a list of Monday to Sun…
Hello, I need to make the ability to lock data for read and edit. I have done it using two line item read/write and then 'Driver Permission' inside module. However, this only locks the top level of th…
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2 While importing the location.csv into the SYS07 Location Details module, the region part is not uploaded properly. why? b…
Hi all, is it possible to show the selected version as a line item in that module? For e.g., I have 3 versions in version settings and have a module with these versions as a dimension: Actual Version …
From a callcenter planning perspective we currently have Erlang B and Erlang C, which allow customers to compute the SLA given an amount of calls and their staffing level. The industry is starting to …
Hello Community, I have the next list named BOM Lvl 1 List, with a Total Price Column, But, I need that if Semi-finish are TRUE, go to the list named BOM Lvl 2 List, and pull the price, adding up the …
Hi Team, I am trying hard to calculate the number of parents for individual list items for unstructured list items. Kindly let me know in case of an optimized formula IF NAME(PARENT(ITEM(Region_Group)…
Hi, question please. I am doing a workflow process approval that once the preparer/inputter submitted to the approver the input cell will automatically locked. Is it possible that the input cells will…
Hello, I have created a module with multiple line items and values for FCST and Budget. I need to calculate the Variance which has a different formula for each line item. What is the best way to do th…
Hi, I need to calculate total loan interest for each month, and every loan was originated in different month. See below example, five loans were originated in different months and amount, and they hav…
Hi there My organisation's Anaplan model was originally built to cater for a "Bottom Up" sales plan , and I am amending it to also cater for a "Top Down" sales plan, when required. We have 2 modules i…
I want to calculate the amount by Weekday. This is the image. Module A ListDay2021/1/12021/1/22021/1/32021/1/42021/1/52021/1/62021/1/72021/1/8LineItemWeekdayMonTueWedThuFriSatSunMonLineItemAmountA100 …
Hi Everyone, I'm trying to find a way for the following challenge: 1. There is a standard business case model for a supermarket that includes such lines as CAPEX, Revenue, Expenses, etc. The standard …
Hi, I have a question about calculating the turnover rate. To calculate it, I use this formula. Formula: IF Inventory <= 0 THEN 0 ELSE IF Inventory <= MOVINGSUM(Demand, 1, 1) THEN 1 ELSE IF Inventory …
Hello everyone. I have created a custom calendar. I have mapped Week(List) and Year(List) corresponding to Time(Days). I would like to create a module that sets the start and end dates to the Week(Lis…
