Set of values: Maximum Selects the maximum value Value expression: Width: Sort expression list: MovingSum Returns the moving sum of the values for the last n rows String1: String2: Concat Concatenates two character strings Character string: Search: Locate Returns the position of a character in a character string Expression1: Expression2: NullIf Compares two expressions Value: Divided by: Mod Returns the remainder of a division Value: Exp Returns the exponential value of the specified value PARTITION BY clause in OVER: Sort Expression: Rank Over Returns an ordered ranking of rows starting with a rank of one Character string: Rtrim Removes blank characters from the right of a character string Character string: LeftRemove Removes blank characters from the left of a character string Set of values: Sum Returns the sum of the values Value: Expression: Result1: Result2: Case Chooses different results based on the value of an expression Character string: RemoveBoth Removes blank characters from the right and left of a character string PARTITION BY clause in OVER: Sort Expression: Percent Rank Over Returns the relative rank of rows CurrentDate Returns the current date Set of values Average Returns the average value Time: HourExtract Extracts the hour part of a time Character string: RightRemove Removes blank characters from the right of a character string String: Length: Left Returns a specified number of characters from the left of a character string Question: Numeric Prompt Prompts the user to enter a specific number Number: Number to Char Converts a number into a character string Time: SecondExtract Extracts the second part of a time Value expression: Width: Sort expression list: MovingDifference Returns the moving difference of the values for the last n rows Question: Character Prompt Prompts the user to enter a specific character Value expression: Width: Sort expression: MovingLinearRegression Returns a predicated value for a column Date: MonthExtract Extracts the month part of a date Date: DayExtract Extracts the day part of a date Numerical expression: Absolute Returns the absolute value of a numerical expression Value expression: Sort expression: Cumulative Sum Returns the cumulative sum of the values Value: Log Returns the natural logarithm of the specified value Character string: Uppercase Returns a character string in upper case Character string: Initial position: Number of characters: Substring Extracts a sequence of characters from a character string CASE expression Complex Case Create a User Object with a complex CASE expression Date: Number of months: Add Months Adds a number of months to a date Question: Date Prompt Prompts the user to enter a specific date Value expression: Width: Sort expression: MovingAverage Returns the moving average of the values for the last n rows First argument: Second argument: If Null Returns the first argument if it is not null, the second otherwise Character string: Length Returns the length of a character string Date: Date to Char Converts a date into a character string Sort expression: Rank Returns the rank of a specified value relative to a group of values Pi Returns the constant value of 3.1415926535897932 Number: Sqrt Returns the square root of a number Date: YearExtract Extracts the year part of a date Quantile constant: Sort Expression: Quantile Returns the quantile scores for the values in a column Set of values: Count Counts the number of entries Time: MinuteExtract Extracts the minute part of a time Set of values: Minimum Selects the minimum value Expression: Coalesce Returns the value of the first argument that is not NULL