-
Avoiding a Circular Reference
Hi, Having a problem avoiding a circular reference when it comes to this Anaplan Formula. The circular refence comes up in the Line Item's "Excess Funding Sweep" when trying to make equal to the "Calculated MCA Sweep to Excess Funding", because the "Calculated MCA Sweep to Excess Funding" references the "Securitization…
-
weekly Time set
Hello,please help me. Start time is the first Monday of each month. Daily data are expressed by week,How to set the time? for example: input:5/1 100,5/2 200,5/3 100,5/4 200,5/5 200・・・6/30 100 want to output :May week 1 = 5/3(Mon)~5/9 week 2 = 5/10~5/16 week 3 = 5/17~5/23 week 4 = 5/24~5/30 week 5 = 5/31~6/6 June week 1 =…
-
Quarterly Totals in Months
Community, In my module for forecasting salaries, I want quarterly totals in months (see attached) to be used for Superannuation calc. But I want to achieve it using MOVINGSUM (or similar) based on a "Pay" line item which resets after every 3 months. Any help would be greatly appreciated! Thanks, Shubham P:S: turning on…
-
Format Column for List Formatted Line Item in Module Blueprint Export
When we export module blueprint to a file, list formatted line item has the list ID as value in the Format column instead of the name of the list itself. It will be useful if the list name is also added so that the exact list used by a specific line item can be known more easily without referring back to Anaplan blueprint.
-
Restrict Time dimension based on User Selection
User will select boolean for Q1,Q2.... or H1 or FY21 etc using boolean only 1 selection, Need to filter module view with with dimensio L1, L2 and time to only the selected time view. Tried many ways, could not able to show H1, H2 etc without Quarter selection as they are summary items. Thanks in Advance
-
How to calculate the cumulative value without using the CUMULATE function
Hi everyone. I would like to know how to calculate the cumulative value without using the CUMULATE function. Please refer to the Excel diagram. I would like to put FORMULA in the LINEITEM of CUMULATE. I would like to avoid using the CUMULATE function if possible, as it degrades performance. Best regards,
-
What is 'Is Organization' in List
Hi Everyone, I was hoping someone could explain to me what is the purpose of 'Is Organization' column found in the List and since this column is greyed out I would like to know how we can untick it?
-
Level 2 Sprint 1- 1.4.3.2 Import Data & Add Formula
Hi, I'm stuck with the activity mentioned in the subject. When I try to add the formula for the Code line item it throws an error(PFA Screenshot). Also, can someone please help me with importing the data correctly? PFA Screenshots. Not sure what I'm doing wrong. Thanks in advance.
-
Volume Entry Worksheet - Training issue
Hi Experts, I am building the worksheet and in the output worksheet, I am missing the Year Total for some reason. I went back and looked at the 'REV02 Volume Inputs' and its looks good. Even when I added this grid to this worksheet, I am getting the summary of the months as FY20, FY21, but when I apply the filter as per…
-
Level 2 Sprint 3
@JaredDolich I have a question about selective access. I built the Stock Exception UX page and then continued to building the roles within Sprint 3. I added selective access to my P2 list for one of the roles. I was going back into my Stock Exception UX page to look at something and I don't have any data because it says my…
-
Snapshotting Issue - Formula Summary for Time Periods
Hello! We are doing snapshots for some key metrics, and I'm facing an issue where a few of the source line items are %ages with a Formula summary for Time period. When these are being imported into the snapshot modules, the quarter value is being messed up because that can't have a Formula summary. I figured I could create…
-
Open the saved view if you save a view
When creating a saved view, it will not open by default, but you need to open the saved view in order to finetune it. It will benefit the model builders, because now a lot of times you create a saved view and you need to remember to open it again before making more changes to the view and continue saving. A lot of times…
-
Changing switchover is giving circular references error
Hello - I'm trying to move forward the switchover date for 1 version in a model and I'm getting a circular reference error message. This is the first time that this has happened. Any ideas what would be causing this / how to fix? FYI - the error message shows a giant list of references that it says are impacted. Thanks,…
-
Model Settings, and lesson 13 help
Does anyone know how we can access our model the way we have been doing this whole time? I have attached pictures of what my model looks like when I log in, and where did the versions, modules, etc settings disappear? I've also circled that under View, there is no save option like there was yesterday? How do I complete…
-
OFFSET v LAG v LEAD
Hi All, I understand each of these functions but could someone succinctly explain the difference. I would naturally lean towards using OFFSET when looking to pull and push data from different time periods so I have never actually used LAG or LEAD in a live build. Where would LAG or LEAD be used over OFFSET?
-
Help Level 2 Sprint 3 - Access driver set up for Product replenishment dashboard
Can some one help me identify what am doing wrong here My formula for Override Amount looks right and aligns with description but am confused on the highlighted piece. Please see my formula and description below. Override Amount – Write? : 'Submit Purchase Order - Write?' AND 'INV01 Inventory Ordering'.Submit Purchase…
-
Optimizer functionality
Has there been any discussion on incorporating multi-objective linear programming in the optimizer moving forward? I'm trying to find a way to incorporate soft constraints into the current optimizer but haven't had any luck. Thanks
-
Enable placement (Before, After, Top, Bottom) of new module upon Insert of module.
Similar to the drop down list when adding a new member to a list, it would reduce steps if I could add the new module to the Bottom of the display or After a selected module. In order to list modules sequentially, eg. SYS01, SYS02, SYS03, I must insert the module, then go back to the modules list and Reorder.
-
TEXTLIST over USER-list
Hi all, They TEXTLIST-function isn't allowed over the USER-list while this would be helpful in some cases. Can this be altered? All the best,
-
New UX Idea - Show History while drill down
New UX is missing one useful feature presented in classic. Show history while drilling down is available in classic. But not in New UX:
-
Move values from flat list to hierarchical list
Hello, Everyone! Please, help me to solve the issue. I have a Flat list with the -1 and 1 values. I have a Hierarchical list consisted from the same code from the flat list but in the hierarchy. There are more than 15 levels. I want to assign every -1 or 1 from the flat list to every element in the hierarchical list. The…
-
Level 2 Sprint 1 1.5.7.3
Hi Team, When reviewing 'Check your Work' my output is similar with the exception of the dimension at the top. Check your Work in the content section has no time dimension at the top only 'Has Data'?. My output includes a date, namely the relevant week. When I try to omit a time dimension, in this case 'week', I'm unable…
-
I want to find if a List item is present in a Line item(formated as earlier List) in a module
Use Case: Users enter values in a module M1 with dimension Project P1. They also enter their name in Line Item LI1 formated as ListUser L1 for projects they update values. Now I want to find with boolean in ListUser Module M2 whether they entered any values or not. So I need to search in LI1 in M1 and return true in M2 if…
-
Native Version Filtering
Hi, Is there a way i can add the native version that has formula in my filtering ? See example below, i need to activate the boolean in my "Act vs FC" version. Thanks in advance for helping. Regards, Tom
-
Level 2 Sprint 3 AD02 query
In Level 2 Sprint 3 I have the following formulae for the boolean line items in AD02 Submit Purchase Order - Write?'INV01 Inventory Ordering'.Submit Purchase Order Request?Override Shipping - Write?'INV01 Inventory Ordering'.Override Shipping Method? AND 'Submit Purchase Order - Write?'Override Amount - Write?'INV01…
-
About Automated Outlier Correction
こんにちは、 統計予測を試みていますが、外れ値について質問があります。 このプロセスでは、外れ値を標準で設定できます。偏差。 しかし、私はこの設定を使用できないと思います、 時系列データには正規分布がないためです。 これについてどう思う。
-
Search Actions in the New Modelling Experience
Hi Team The new modelling experience is great, giving a fresh feel to the design. I like the search option centralized as i don't have to do many clicks. Currently it has Modules, Dashboards and Lists. Can you include Actions too ? Thanks Kudi
-
Line Items Related to Purchase Orders : Confirmed PO Delivery (Level 2 Sprint 3)
* Set the Confirmed PO Delivery line item to use the PO Submitted 1 value and OFFSET it based on the number of weeks between the order and delivery. For example, if a PO Submitted has a value in Week 1 and the Shipping Time Weeks has a value of 2, there would be a value of 1 in the Confirmed PO Delivery line item in Week…
-
Upload local image on to UX pages or Dashboard
Hi, I have an image(JPEG file) in my desktop given by user which need to be displayed on UX pages. I can see URL option is available in Anaplan to upload images. Is there any other way for uploading local image files?. Thanks, Suman.
-
Keyboard shorcuts.
Hi, for newcomers to Anaplan, a tip I posted 4 years ago and that I find worth being posted again with some actualisation. I am using keyboard shortcuts all the time on Anaplan. CTRL C / CTRL V are obvious for anyone, and very efficient in Blueprint for properties copy and paste. I find two other shortcuts very usefull and…