-
Concatenate values
Hi guys, i would like to know if its possible to concatenate values like this to create a code: - i have three line items : Year; Currency; Group - the final output i want for my code is : TypeYearCurrencyGroup i dont want to add a list or create a manual entry for 'Type' because it will always be the same since there is…
-
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…
-
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…
-
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
-
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
こんにちは、 統計予測を試みていますが、外れ値について質問があります。 このプロセスでは、外れ値を標準で設定できます。偏差。 しかし、私はこの設定を使用できないと思います、 時系列データには正規分布がないためです。 これについてどう思う。
-
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…
-
Display only the items created by a user (within a list dimension)
Hello, Here's what I'm trying to achieve: Person A: John Smith (john.smith@hello.com) List Item: Department: Finance When John opens the App, he should only see the 4 products he created under the Finance Department list dimension.…
-
Level 2 Model Building: Sprint 3, INV01 Inventory Ordering
Why are my values for forecast demand and suggested order amount for the month slightly off (by 2 units) at the SKU level? The amounts are off by larger amounts at the "All Products" level. Also, how do I make it so that the Safety Stock Target will only show at the SKU level?
-
Is it possible to override number formatted line item default value to BLANK
Hi, Is it possible to override number formatted line item default value to BLANK? Suman.
-
Retrieve the current user from another module
Dear Expert, Good day! Is it possible to get/retrieve the current user from Module 1 to Module 2 even there's no Users list used in Module 2? So that the user will no longer select/choose on the dropdown in Module 2. The reason why we didn't put the Users list in Module 2 because of workspace size issue. Please see…
-
Formula for subsidiary view item
Hi! I have a question about formula in subsidiary view. I have a line item with different dimensions. What should I refer to in the formula so it would work (and can be seen) in subsidiary view item? Other items in the module are in regular dimensions.. And I would like to use them in the formula for subsidiary view item.…
-
L1 Model building - 6.6.5
Hi, I'm trying to add the formula 'SYS00 Time Settings'.Forecast Period? to mi line item but I keep getting an error pop up. If somebody knows what's wrong thank you in advance.
-
creating Sys Account SKU Filter
what formula should I use to check if the total of all product SKU volumes over all time periods the value is not equal to zero?