-
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?
-
Formula to find the age
Hello, Can you please help me with an info? Is there any formula that can be used to calculate the age if we have the date of birth? Thanks
-
Anaplan "Concat" & "Nested IF" Best practices
Hi Anaplaners, I have a module with 5 Line Items, all formatted as text. I have to concatenate the first 4 and give the output in 5th. However , out of the first 4 only the ones which have a specific value will be concatenated. (Eg. if 1st is "ABC" only then it will be a part of concatenation else not.) So there can be 16…
-
Model Id Changed from restored Archive Model ?
Hi, Will the Model ID change when you restore a model from an archive ? Do i need to update all script in Anaplan Connect to load/extract data from the newly restored model ? Thanks, Tom
-
Average 3 months data
Hi, For your assistance please. I want to get the average of the past 3 months, however, the average result should be post to the remaining months. In the screenshot below, I created three lines items: Commission % - input data Latest 3 Months Average (Comm%) - I used this formula MOVINGSUM(Commission %, -2, 0, AVERAGE)…
-
Unable to edit the cell
Hi, I'm trying to make the last cell "SDR Action Plan" editable but it doesn't allow me to do it. Please let me know what mistake I've made. Thanks.
-
Period() Function -- Driven by Model Calendar Settings?
Hi All, Was doing some review reading and saw the note on the Period() function, for which I've always been a bit "hazy". ...From the instructions, it looks like the key thing is that results of this one are driven by/determined by the settings in the Model Calendar ("Time Bounds"?): * Result must fall within the Time…
-
Apply filter on time when it is in page selector
Hi I have 3 Versions, and time as a dimension 5 years in modules. For Test Version1 I should see FY 19 and FY 20 past and current year. For Test Version2 & Test Version3 I should be able to see all time periods. For that I have created one filter(version and time specific filter) line item to filter the time based on the…
-
How to calculate Month to month Growth Rate?
Hi all! What is the way to calculate Month to Month Growth rate (from the beginning of the time scale) if I have Sales Volume by month at monthly timescale? I have: (Volume by Month - PREVIOUS (Volume by Month)) /PREVIOUS (Volume by Month)* 100% I wrote the formula but it doesn't match the math result (when I'm making…
-
Add number of business days to a date
Hi, I'm trying to find a date that is day 5 or 7 or 16 business days later than Start Date, based on a cell that contains Num Biz Days. I've created a Calendar module where I exclude weekends and holidays I've marked such that I have a Cumulative Working Days where I can Lookup Start date (say it returns 341th working…
-
Time Filter on Page Selector
I need to filter the data in modules for Test Version(1) in current year. For that I have created one filter(version and time specific filter) line item in to filter the data for current year and Test Version(1). This filter is working fine in the modules where time is in columns but I'm not able to apply this filter where…
-
No Settings Tab
I can only see the contents of my models and there is no settings tab. What happened?
-
How to create a filter
Hi @ChrisAHeathcote Appreciate if you advise on how do I create a filter for a column name I'm trying to create a filter by "account type" . Thanks.
-
Why is a line item referencing another where both have no overlapping applies to ok?
Lets say I have a line item LineA with an Applies To of Users, and a line item LineB with an Applies To of Organization. Anaplan lets me make the formula of LineA, "LineB". I understand the principal of using SUM/LOOKUP/SELECT etc. to find the values in each dimension to use where the dimensions are missing from the line…
-
Avoid circular reference using list member logic
Hi all, I’m new to Anaplan and would really appreciate help with the following: I'm trying use the same module ('Module A') for two stages of a calculation (before and after); for this, 'Module A' has only one dimension; a list or two members ('Before' and 'After'), image attached. it's first line item (Item A1) sets a…
-
Want to be able to display a property of a list as a dimension
Hi Anaplanners! I want to be able to display a property as a columns on a Dashboard. Let me know the best way to do it. Thanks in advance! Regards, Garima
-
Is it possible to hide row Dimension list in Dashboard
Hi, I have a module with two list(one list as page & second one as row) with multiple items. When i am displaying this module into dashboard i want to hide row list. Is it possible to do that?. Thanks! Suman.