Appendix A: Functions Table
NEW SAVED FUNCTION | Adds an already saved function to the table. |
|---|---|
LOAD SAVED FUNCTION | Loads an already saved function to the table. |
COUNT | Counts the number of times the target Field occurs. |
SUM | Collects the sum of all values in the target Field. |
AVG | Collects the average value of the target Field. |
MIN | Captures the smallest value in the target Field. |
MAX | Captures the largest value in the target Field. |
DAY | Displays the day number from the target Date. |
MONTH | Displays the month number from the target Date. |
YEAR | Displays the year number for the target Date. |
MONTHYEAR | Captures the month and year as a string from the target Date. |
DATEPART | Captures the specified part of the target Date. |
DATEDIFF | Captures the difference in specified parts (day, month, year) between two target Dates. |
DATEADD | Adds a specified part (day, month, year) a number of times increment to the target Date. |
SUBSTRING | Captures a part of the target Field starting at the "Start" index and is "Length" characters long. |
REPLACE | Replaces in the Field any occurrence of the "Overwrite" value with the characters in the "Replacement" value. |
RIGHT | Captures a substring of the Field consisting of the rightmost "Length" characters. |
LEFT | Captures a substring of the Field consisting of the leftmost "Length" characters. |
PERCENT | Displays the percentage for the Field value. |
CONCATENATE | Displays multiple values together in a single column. |
ADD | Displays the sum of two different selected numeric field values. |
PIVOT | A pivot is a method that takes unique values from a column and turns those values into multiple columns, while aggregating other column values. |
Related Content
-
Report Builder
Format:
Article