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 formula: lists: Job type: TEXT (example: accountant, Sales...) Employee: TEXT (employee name) 1) MEDIAN "Applies to ": Job type MEDIAN = IF 'MAX/2' * 2 = 1 THEN Wage ELSE IF 'MAX/2' * 2 = 2 THEN Median intermediate ELSE Median intermediate 2) MAX/2 "Applies to ": Job type "Summary": MAX MAX/2 = Rank per job type[MAX: Job type] / 2 3) Rank per job type "Applies to ": Job type, Employees Rank per job type = RANK(Wage, DESCENDING, MAXIMUM, Wage > 0, ITEM(Job type)) 4) Median intermediate "Applies to ": Job type, Employees "Summary": MAX Median intermediate = IF 'MAX/2' * 2 = 1 THEN Wage ELSE IF 'MAX/2' * 2 = 2 THEN Total Wage per job type / 2 ELSE IF 'MAX: round up' = 'MAX: round down' THEN IF 'MAX/2'[LOOKUP: Job type] = Rank per job type[LOOKUP: Job type] THEN 'SUM: Wage related to MAX round down' / 2 ELSE 0 ELSE Wage related to MAX round up 5) T otal Wage per job type "Applies to ": Job type T otal Wage per job type = wage[SUM: Job type] 6)MAX: round up "Applies to ": Job type "Summary": MAX MAX: round up= ROUND('MAX/2', 0, UP) 7)MAX: round down "Applies to ": Job type MAX: round down= ROUND('MAX/2', 0, DOWN) 8)SUM: Wage related to MAX round down "Applies to ": Job type, Employees SUM: Wage related to MAX round down = Wage related to MAX round down 9)Wage related to MAX round up "Applies to ": Job type Wage related to MAX round up = IF 'MAX: round up' = Rank per job type THEN Wage ELSE 0 10)Wage related to MAX round down "Applies to ": Job type, Employees Wage related to MAX round down = IF 'MAX: round down' = Rank per job type OR 'MAX: round down' + 1 = Rank per job type THEN Wage ELSE 0 Emmanuelle
... View more
