Exago Logo
Search
Generic filters
Exact matches only
Formulas and Functions

Custom Function: Year to Date Check

Returns true if the provided date value is within this year to date, otherwise returns false.

String Functions

String functions are commonly used for interpreting and manipulating text fields. ConcatenateDescription Joins several text strings into one text string.Remark The "&" operator can be used instead of Concatenate() to join stringsExample Concatenate("This ","is ","one ","string!") ...

What are formulas?

Formulas allow you to do calculations, parse strings, insert images, and much more. Formulas are the composition of functions, parameters, Data Fields, and references to other cells.

Database and Data Type Functions

Used for determining the type of information contained in a cell. Helpful for error and sanity checks.DataRowCountDescription Returns the number of rows retrieved from the data source when executing the report.Example Suppose report is run to retrieve basic information on ...

Date Functions

Date functions can be used to do calculations and formatting on date and time values.v2019.2.35 v2020.1.18 v2021.1.6 For all of the functions below except for DateCustomFormat() and Time(), passing Null(), DbNull() or any value that resolves to Null() or DbNull(), including null in a ...

FilterValue and General Format Best Practices

The FilterValue function may take up to three arguments: Required: the filter’s index in the list of filters Optional: the sub-index, starting with 1 for filters that contain multiple values (e.g. filters with an Is Between, Is Not Between, Is One Of or Is Not One Of operator). If ...

Financial Functions

Common methods for monetary calculations such as interest and depreciation.DbDescription Returns the depreciation of an asset for a specified period using the fixed-declining balance method. Cost is the initial cost of the asset. Salvage is the value at the end of the depreciation ...

Custom Function: Last Year to Date Check

Returns true if the provided date value is within last year to date, otherwise returns false.

Formatting Functions

Apply font styling changes (bold, italic, underline) to cell contents. BoldDescription Applies bold font weight to the input.Example="The second half of " & bold("this sentence is bold.") The second half of this sentence is bold.ItalicDescription Applies italic ...

Custom Function: Month Check

Returns true if the provided date value is within a full specified month, or a specified month to date. Returns false otherwise.

Formula Editor

Starting in v2017.2, the Formula Editor has a suite of features to help guide you when using formulas.You can use the Search field to search through the functions by name. Or start typing in the Formula field to get a list of functions that match the text. List of functions that match the ...

Internal Parameters

The following parameters are built into the application and can be used on any report. Their names are reserved and cannot be overridden. Report Specific Parameters The following parameters are utilized within reports to gather specific report information. pageNumberDescription Display the ...

List of Functions

All built-in functions are listed here.

Logical Functions

Logical functions can be used to handle conditional information.AndDescription Returns TRUE if all its arguments are TRUE; returns FALSE if any argument is FALSE.Remark The arguments must evaluate to TRUE or FALSE.NOTE. The And function can take more than two arguments as ...

Other Functions

CellValueDescription Returns the value of the current cell.Remark Used in Conditional Formatting.Example Suppose a cell of a report displays the price of products.Ex. CellValue()> 150 returns True if the price of the product is greater than ...

Custom Aggregate Function: AggConcat()

Returns a concatenated string of values separated by a specified delimiter string.

Custom Aggregate Function: AggCountIf()

Returns the count of values of dataToAggregate with a corresponding true condition. Only those records with a true condition are included in the count.

Aggregate Functions

Aggregate Functions calculate values based on two factors: the input cell, which is usually but not always a data field, and the report section that the function is located, relative to the input. The location of the function determines which, and how many cell values will be sent to the ...

Custom Aggregate Function: AggDistinctAvg()

Returns the average of only unique values in a series of values.

Arithmetic and Geometric Functions

Basic mathematical functions, as well as number field manipulation like truncation and rounding. AbsDescription Returns the absolute value of a number.Remark  ExampleAbs(-23.1) – returns 23.1.AcosDescription Returns the arccosine, or inverse cosine, of a ...