Calc
Performs a calculation on either a frame or the table items inside the frame.
Parameters
| Name | Default | Meaning |
|---|---|---|
| name | The name of the final attribute/column | |
| value | The value to be written. Substitutable. | |
| where | A condition that must be met for the calculation to happen. | |
Description
This function performs a calculation on a frame, or - if the frame contains a table - the individual items within the table.
This will normally be applied to every column/frame, unless a where condition is specified. If a 'where' condition exists, the calculation will only happen on frames and columns that match the condition.
Example
If the frame contains the following attributes…
| Attribute | Value |
|---|---|
| Width | 100 |
| Height | 100 |
{ "type": "calc", "name": "Area", "value": "{Width} * {Height}" }
The final results will include the Area attribute with a value of 10,000. If 'Width' and 'Height' were in the table instead, a new column called 'Area' would be added.