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 150.

1. The index, starting with 1 of the filter.
2. The sub-index used for filters that contain multiple values (i.e. between or one of).
3. (Optional) a boolean to determine if the value should be formatted following the user's culture settings. This is used for numbers and dates.

   If there are no filters the function will return an Index out of Range message.

   Note

   The optional third argument is not recommended for use in computational formulas. For more information about best practices, review the Filter Value and General Format Best Practices article.

Ex. FilterValue(2,2) returns Tofu.

Creates a hyperlink to an external website. Available for all report types except for CrossTab Reports.

1. The URL of the website.
2. (Optional) the text to display in the cell.

If the second argument is omitted, the URL will display.

Note

If PDF exports open in a tab within this application, then clicking the hyperlink may direct a user to leave the application.

Note

Hyperlink() must be the outermost function in a cell. It may not be used inside conditional functions (i.e. If or Switch) or nested in other functions.

Hyperlink(‘www.fakeWebSite.com’, ‘click here’) returns a hyperlink that displays the text ‘click here’ . Clicking this text will open http://www.fakeWebSite.com.

Ex. LoadImage("C:/StarryNight.jpg")

Ex. LoadImage("https://mywebsite.com/logo.png")

Removes any HTML tags from the input string.

Ex. StripHtmlTags("<h1>This is heading 1</h1>") - returns This is heading 1.