-
Re: Sorting then summing down a list
Jack 1. True, but this would add some additional complexity to the formulae required to perform the triangle comparison 2. Also true, if every module within a model has 2 or fewer dimensions it would…1 -
Re: Day of Week
There's a new calculation function due in the 2015.4 release (Oct) which does this; the details are... "WEEDAY(date, #). This new function has been added. It returns the day of the week (e.…1 -
Re: Timescale related formulas
I would suggest adding properties on your new time dimensions and setting the previous and next and any other values you may need. Then call those properties with month.next or something similar.1 -
Re: Anaplan equivalent of the "Product" Function
Would creating a series of Line Items that take logarithms, perform a summation and finally take exponents suffice?1 -
Re: How to use Time Period Format in a Date Formula
Sorry for the late reply. You can use the formula YEAR() to convert a Year-formatted line item to a number, and use it in a DATE()-formula. For example DATE(YEAR("year formatted line item")…1

