whatโs the difference between using:
[column]
[this]. [column]
[_this row] .column]
Use [Column]
to refer to the value of the Column column. See Column Value Expressions
Use [_THIS]
in column constraint expressions to refer to the current value of the column to which the column constraint applies. See Column Constraints.
Use [_THISROW].[Column]
within FILTER(), LOOKUP(), MAXROW(), MINROW(), and SELECT() expressions to refer to the value of the Column column of the row from which the expression was evaluated, rather than the row being examined; use [Column]
(without the leading [_THISROW].
) to refer to the value of the Column column of the row being examined.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
13 |