Hi, I'm trying to implement model where users could easily apply filters on customer list based on segments and subsegments. Problem is that when the user list is filtered by segment or subsegment the…
How to create a SUM formula from a list but the format of the line item on the list is text and how to automate upload data from SQL server into Anaplan thank you @josephine_surja
I need some pointers to tell me what went wrong. 1) i created SYS08 SKU Details a column Country made in-----PARENT(Supplied By) 2) In INV02 i used the formula---- 'INV01 Inventory Ordering'.Safety St…
Hi, I'm trying to replicate this Excel Function in Anaplan. I want to make sure my Anaplan Function is picking up all the values for my Line Item from the begging through the end of the month, and not…
Hi, I'm not sure how to make my Line Items into inputs(blue). They do not have formulas in them so not sure why they are not allowing me to make them inputs. Please advise. Thank you Pic attached
Hi We are using the line item 'Month' in one of the module, and the objective is to derive the current month so that we can capture the purchase trend of our hardwares.When I try to use the formula as…
Trying to understand what is wrong with this formula and why it doesn't give me 2019-2022. Instead, I only get 3 years, 2020-2022. If I change the formula to Prior Year -2 I get 2021-2022. Would appre…
Hi All, Can you please help me to understand visually what is the difference between system module and saved view as per below instructions :- SYS05 Saved View :- Let me know please if i am doing any …
Hi All, Can anybody suggest to me what I do to include subset line items in the saved view for SYS07 Location details :- I know how to create the subset line items, but can't figure out what to do wit…
Hi, I am trying to enter the formula for a question in L2 S3 exam. It says my answer is incorrect but in the model it is giving me the desired result. I want to confirm that my understanding about AD0…
Hello All, I am having trouble getting my summary method to work correctly. I have a line item that is set to formula scope 'Actual Version'(this cannot change), but I would like to use the summary me…
Hi All, I have created the list subset as below , but I am unable to select the desired line item of a referred module in List Subset :- List subset :- Referred Module :- Thanks Vivek
Hello everyone, I'm trying to build a solution I have not yet encountered before. The assignment is to plan a "chain of activities" and the amount of hours they cost over time. Each activity is trigge…
I am trying to figure out the difference between LEAD and LAG function; as we can get same value from future and past period by using both function. for Ex: LEAD(x,-2,1000,STRICT) and LAG(x,2,1000,STR…
REP02 SIZE MARGIN REPORT- Revenue & Cost of SalesHI Team The values for Revenue & Cost of sales are not appearing in the REP02 Size Margin Report. Have attached the Screenshot for your review.. can yo…
I believe this is straightforward, however I haven't been able to word my searches to find what I'm looking for - so either it doesn't exist or I cannot find it. Going to throw this out there: Our gen…
Is there any equivalent or trick to returning 'fractionalagents'? AGENTS(w, t, y, z) will always return a whole number. My stakeholders are interested in both whole/fractional agent calculations.
I have a module that is using Versions-All but all versions are not pulling into the module. My Forecast and Actual versions are missing. What may be causing this? Other modules that I am using are sh…
Hi All, I have reference the data using the formula but still the data is not coming, can any body guide me what is the issue and how i can resolve it? Below is the screen shot of Module EMP 02 in Gri…
Hi All, I am trying to import the text file(attached) in module SYS08 (below screenshot), even though I have tried to get the data in CSV format and do the same, but still, the data like employee name…