Common use of Text Clause in Contracts

Text. First Return the value of the first record. Last Return the value of the last record. Count Return the number of items. Null values are not counted. Count(Distinct) Return the number of distinct items. Null values are not counted. Add Range You can aggregate data into ranges without the need to create any additional calculations in the data source.

Text. First Return the value of the first record. Last Return the value of the last record. Count Return the number of items. Null values are not counted. Count(Distinct) Return the number of distinct items. Null values are not counted. Add Range Range‌ You can aggregate data into ranges without the need to create any additional calculations in the data source.