To address a cell, you need to specify the name of the column, and optionally a row selector expression.
If you do not specify a row selector expression, the right hand side expression will be evaluated for every cell in the column.
Use @< column > to address all cells in a column.
Example@Amount = 10; will assign the value 10 to all cells in the Amount column.
Use @< column >[expression] to identify one or more cells.
Example@Amount[AccountID = "N-3000"] = 10; will assign the value 10 to all cells in theamount column where AccountID or the row equals the string N-3000.
Row selector expression
The Row selector expression specifies the condition for matching rows in a data set. The expression may return 0 or many rows.
The operands in an expression can be hard coded values, such as strings and numbers, column references and functions.
For example, a typical expression may look as follows, where ItemID and RefID are columns in the data set being processed. The expression matches all rows where ItemID equals "NO-765-P" and RefID starts with "X".
@SomeColumn[ItemID == "NO-765-P" && LEFT(RefID,1) == "X"].
This example shows how to select all cells in the Amount column where AccountID = 2000 and ProjectID is N-500Amount[AccountID == "2000" && ProjectID == "N-500"]
This example shows how to select all cells in the Amount column where AccountID = 2000 and ProjectID starts with N@Amount[AccountID == "2000" && LEFT(ProjectID, 1) == "N"]