Built-in Functions and Calculations

While most users creating a Computed Items will choose to leverage the built-in Interactive Reporting functions to write calculations, it is important to completely understand the functionality provided within each built-in function. Once fully understood, the functions provide the gateway for building computations, filtering data, and preparing data for other presentation sections. The following content in this section breaks down each built-in function and provides examples of commonly used functions.

Conditional Functions

Conditional Functions in Interactive Reporting are specific to replacing content of a field based on a set of conditions. There are only two functions that exist in the Conditional Function grouping. The functions are Nvl and Decode. The Nvl function is used to...