FormattedData (PQL)

Returns the formatted string value of a data point or cell for the given row and column index coordinates from a query result set

  • Returned Output: Text
  • Library: PQL \ Dynamic \ Grid
  • Version: 2018.00.000
  • Compatibility: Any content (regardless of data source) in the relevant parts of the application

Syntax

FormattedData( <Row Integer> , <Column Integer> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The row and column zero-based index numbers must be supplied to indicate which data point to return.

Examples

The examples below use the following example grid.

This example returns the value 233,194.03:

FormattedData(1,0)

While this method will return the raw numeric value 233194.03:

Data(1,0)