PrevContributor 
-
Re: Depreciation Using Profile Formula
Hi Ankesh, If you are going to be spreading the expenses evenly over 5 quarters, you could use: SPREAD(expense line item,5) If you have a custom spread, then the attached screenshots will show you an…3 -
Re: Collecting the value of a parent list in calculations
I think it may be the syntax Employees.PARENT(ITEM(Employees))], is it looking for a list item named PARENT(ITEM(Employees)), not the actual parent? I believe you have to take a two stage approach [l…3 -
Re: Changing Line Item Formula to Refer to List Subset Instead of List.Property
Hi Chris, Based on this comment - "now Module ABC applies to Account_List, and Module XYZ applies to Account_Subset, which is a subset of Account_List" it sounds like you no longer need the…3 -
Re: How to Calculate Months Difference between Two Dates
Michael - an alternative method is (Year(EndDate)*12 + Month(EndDate)) - (Year(StartDate)*12 + Month(StartDate)) This returns the number of calendar periods and is valid for some calculations. Best, …6 -
Re: Single module, multiple modules?
There is no rule of thumb when building modules in terms of number of dimensions or line items as each company's model will vary significantly. One great thing about Anaplan is that we are not l…4
