Power Script Examples

Worked Power Script Flow Steps. A Power Script runs once for each record in a Query's result, and it can change the record in place through $record: add Fields, change values, or drop the record entirely. The aggregate examples also use $local, which keeps its values from one record to the next (see Reserved Power Script variables).

In this section

Article	In one line
How to calculate a sum total aggregate via a Power Script	Total one Field across every record and write the grand total onto each row.
How to aggregate values on specific groups of data	Keep a separate running total for each group, such as each salesperson.
How to compare two dates in a Power Script	Add a column that says whether two date Fields match.