Referencing Row Number in Variable

Prepify

I have a queried table with 1 row. I want to reference the first row in the table in a formula. How do I do this?

For example: TableName.ColumnName Row 1.
I tried TableName.ColumnName[0] but it didn't work

Also returning the query as a "single" is not an option since its an aggregation.

Michael Udinski

@Peter Nooteboom - You can use Dot Notation with the index. So it'd be:

VariableName.ColumnName.0