-
Re: Sort when there are 2 dimensions in row
Hello Alejandro, thank you for your reply. I've already tried to create a line item ( item(time) ): but Anaplan doesn't allow us to sort anything on a line item when there are 2 dimensions on a a row…1 -
Calculate median value
Hello, the MEDIAN Anaplan function doesn't exist ("No native Anaplan function: can be built using calculation"). I have all the wages of my company and I need to calculate the median wage p…5 -
Re: Calculate median value
Dear both, thank you for your help. I found out the solution (I've checked with Excel), which is a little bit more tricky 😉 It would be nice if Anaplan edit a MEDIAN formula 😉 Here are the line item …1 -
Re: Payment every year
Thank you Rob & Dameyer. I've found a solution : A- payment ?= '1st payment ?' OR Next payments ? B- next payments ?: IF Payment frequency = Payment frequency.Yearly AND Payment # - 1 = 12 THEN T…1