-
ANAPLAN Optimization for N users
Hi , If we have users of around 10000000 in Sales team and we are using that list (Users) in one module so how can we optimize the structure of module as if that module page is published in Dashboard then it will take time at great extent to open and to load so how can we optimize the page of dashboard so that the user…
-
How to delete duplicated employee records due to movement
Hi, I have a scenario where we have created gap process to hire new resources, essentially adding new lines in our employee list. However one problem coming up is sometimes we created a gap and then an existing/internal team member applied and got the job. Not sure if there is a way we can somehow delete the original…
-
Summarizing only Negative numbers and Positive Numbers in separate Line Items
Hello, I am trying to solve a dilemma. I have values for a list property called "adjustments". These values can be positive or negative and there can be more than one in the same time period for the same product. (eg: Apples in December 2020 had one adjustment for -10 and another adjustment for 20. The Net effect of these…
-
Working Days Calculation
Hi, I have been using the long formula for working days suggested in the Anaplan help, and it's been giving me some issues, so I created a new one It's shorter and easier to follow and thought I would share You need 5 fields* *Holidays is optional and can be removed example of calcs Hope it helps Kev
-
Circular Reference with CUMULATE
Hi All, I am trying to solve an excel model in Anaplan where my current value is a calculation of the cumulative of previous values. The calculation works fine in excel but I am unable to break this down in Anaplan. I am adding the screenshot for the logic of this model below. Any help or suggestions would be helpful.
-
Trouble importing BookPrice
Hello, I am having troubles when I import the data from the Price Book that I downloaded from Anaplan Learning. The numbers imported are inserted with a multiplication of 100 (e.g 0.84 USD ==> 84 USD), so my margin calculation is all false! What should I do ? PS : I have applied the same Format for the line items as…
-
decimal places more than 15 do not total right:
Dear Team, I would like to seek for your enlightenment on this area. I tried to copied several times an amount (percentage in real number format) with a decimal places of 19-20. it copied correctly in anaplan and i selected the number format of significal number to 15 places. However, it does not total correctly. it would…
-
Level Model 1 Builder 9.2.5 Formula Error
Hi - I am still getting an error after trying to put a space after "Unit Price% ". Can someone help to see what might be wrong?
-
Filer - The ability to show Items that match ALL and ANY
Dear Anaplan Experts, Please see the pic attached. I would like to create a filter that shows items that match ALL for three boolean criteria (i.e. show the record if ALL are met) and ANY for two number format criteria (i.e. shows the record if any of them are not equal to zero). Would it be possible? Thanks, Lily
-
Is it possible to maintain a Line Item Subset's original formatting?
Hello, I have run into a problem in which I created a module using a Line Item Subset and used a COLLECT() formula to pull the data in from the original module. My question is whether or not it is possible to retain the original modules Line Item's formating. As you can see in the original module (without the line item…
-
Totals and filtering
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 customer total doesn't change. Filter is made on user level. Amount of customers, products and users is so high that I…
-
SUM function from a list with text formatted line item
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
-
INV02 - Safety Stock Flag Count line item formula - Level2
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 Stock Exception Count[SUM:'SYS08 SKU Details'.Country Made In] but i came out the error below. I have P3 aggregated to P1 in…
-
Formula using Min Function
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 just the beginning and end month numbers. I have the Formulas below. Please advise. Excel Function…
-
How to make Line Items into inputs?
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
-
Deriving the current Month
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 Month= ITEM(Time), I am getting the error message as shown in the screenshot. I have also attached the settings of…
-
Sys: Time Module Formula
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 appreciate any ideas.
-
Saved Views
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 mistake ? as in furher topics if i am importing these saved viewes I am not getting any data populated in lists.
-
Activity - subset line items
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 with subset line items? which module i can refer having number as format etc ?? so request you to please help me to complete…
-
L2MB-S3 AD02 Override Amount formula
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 AD02 is correct. Override Amount - Write? is a Boolean formatted line item. Formula for this line item is based on INV01…