About manuebilly

manuebilly · ‎01-04-2019

Dear all, thank you very much for your help. Emmanuelle

manuebilly · ‎12-27-2018

Dear Anaplaners, What is the Anaplan equivalent function for the "Match" Excel function. I have a list "Age braket": 0 to 10 years 11 to 20 years 21 to 30 years Above 30 years I have 2 line items: Age : format number Age range : format: list "Age bracket" If "Age" is 25 , I would like to edit a formula in "Age range" with a result of "21 to 30 years". I would like to avoid a formula with if "age" < 11 then "0 to 10 years" else.... Thank you for your help. Emmanuelle

manuebilly · ‎08-24-2018

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

manuebilly · ‎08-21-2018

Hello, Do you mean ?: Line item 1: Wage [SUM: Job type] Line item 2: RANK(Line item 1, ASCENDING) Line item 3: MAX(Line item 1, Line item 2) / 2 Regards, Emmanuelle

manuebilly · ‎08-20-2018

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 per job type. How can I do ? Thank you for your help.