Written by Calculates the average from specific entries in a database.
Returns the nth ranked member from a set, useful for identifying top performers, like sales leaders or highest achievers in a list.
Retrieves a member or tuple from a cube hierarchy, confirming its presence within the cube.
Identifies the date of the next coupon payment following the settlement date.
Calculates the number of days from the settlement date to the succeeding coupon date.
Inserts a clickable link into a cell.
Returns the decimal value of the first character’s Unicode.
Eliminates extra spaces at the start and end of a given string.
Merges text from various strings and/or arrays, using a specified delimiter to separate them.
Returns string inputs as text data.