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. 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 omitted, filters with multiple values will return a comma-separated list of values.
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.

   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.

FitlerValue(1) returns 3.6
FilterValue(2) returns Boston Crab Meat, Tofu
FilterValue(2,2) returns Tofu

Create a hyperlink to an external website. Available for all report types except for CrossTab Reports. The link will open in a new window/browser tab.

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.

Note

LoadImage() 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.

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

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

Ex. LoadImage({Employees.Photo})

Removes any HTML tags from the input string.

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