Calculate new column transformation allows calculating new columns using expressions (i.e. formulas).
Rule transformation can be used for calculations that are nested IF/THEN/ELSE conditions. This transformation is similar to CASE statements in SQL. It can be used to create new columns as well as replaces existing ones.
To calculate grouped aggregates such as sum or count, use Aggregate transformation.