Calculate column
The Calculate new column action allows calculating new columns using
expressions (i.e. formulas).
Similarly, the Modify column action replaces existing columns. Note
that it's possible to create/modify several columns in one action.
Rule
The Rule action can be used for calculations that are nested IF / THEN / ELSE
conditions. This action is similar to CASE statements in SQL. It can be used to create new columns as well as replace existing ones.
Aggregate
To calculate aggregates (grouped or not) such as sum or count, use the
Aggregate action.
Advanced topics
Referencing values from other rows
As you may have noticed by now, in EasyMorph the approach to calculations is different from Excel. The expression syntax is more restricting (which, by
the way, is good for performance) and doesn't allow referencing values in other rows, tables or aggregations over ranges. Nevertheless, such calculations
are still possible with the help of additional actions that pre-calculate/bring necessary components of a value calculation into the same row. For
instance, the Shift columns action can be used to bring values from a
previous or next row. Then they can be used in an expression together with values from the current row, which makes it equivalent to referencing a value
in a previous/next row. Note that in EasyMorph it's generally not possible to arrange recursive calculations. Although in some cases workarounds are
possible.
Using totals/subtotals in calculations
The Total/subtotals action creates a new column with an aggregated total, or
group subtotal (if grouping was used). This action is different from "Aggregate" because it doesn't roll up rows, but instead just adds a new column with
total/subtotals. It makes it possible to write expressions that use a row value and its column total (or group subtotal) in the same expression (e.g.
calculation of the percentage from the max value).
