Description
Performs mathematical operations on reporting data. The results may be saved as a variable, accessible in the current context.
Parameters
Name | Required | Migratable to Cloud? | Default Value | Description |
|---|---|---|---|---|
[default] /name |
|
| If provided, the result of the evaluation will be stored in a variable with the specified name. It is accessible via the Variable Supplier (e.g.: "variable:foo"). | |
default |
|
| An %injectable% value that will be used if the expression does not evaluate to a valid result. | |
format |
|
| A number format to output the result with. e.g.: "#,##0.00". | |
hidden |
|
| false | If set to true, the result will not be output. |
Editor View
Not applicable.
Macro Edit View
Not applicable.
Notes
This macro differs from Scaffolding's Evaluate Data in a couple of ways.
The value is only stored temporarily. It can't be accessed from another page, for example.
It can access values outside of the Scaffolding add-on. Any number you can access from a Supplier can be used in a calculation.
There are no special functions for sumtable or avgtable. Instead, use the Stats On Supplier to generate that kind of data.
Expressions
Expressions can be made up of the following:
Description | Value |
|---|---|
Description | Value |
Numbers | 1.234, -987 |
Variables | %prefix:value% |
Basic operations | +, -, *, /, ^ |
Trigonometry functions | sin(X), cos(X), tan(X), cot(X), sec(X), csc(X), arcsin(X), arccos(X), arctan(X) |
Exponential functions | sqrt(X), exp(X), ln(X), log2(X), log10(X) |
Shift functions | abs(X), trunc(X), round(X), floor(X), ceiling(X) |
Constants | pi, e |
Brackets | ( <expression> ) |
Logic-valued expression | ( <logic expression> ) ? <true value> : <false value> |
Logic operators | =, <>, <, >, <=, >=, !, &, |, |
Examples
Basic Mathematics
The following example simply calculates the value of a fraction.
Numerator: {number-data:Numerator|decimal=true}1{number-data}
Denominator: {number-data:Denominator|decimal=true}2{number-data}
Result: {report-eval:Result|format=#0.0}%data:Numerator%/%data:Denominator%{report-eval}
Percentage: {report-eval:Percentage|format=##0\%}round(%variable:Result% * 100){report-eval}
Result
Numerator:1
Denominator:2
Result:0.5
Percentage:5000%
Cylinder Calculations
Calculate the properties of a cylinder based on its radius and height.
|| Radius | {number-data:Radius|decimal=true} cm ||
|| Height | {number-data:Height|decimal=true} cm ||
|| Base Circumference | {report-eval:Circumference} 2 * pi * %data:Radius%{report-eval} cm ||
|| Base Area | {report-eval:Base Area}pi * %data:Radius%^2{report-eval} cm ^2^ ||
|| Side Area | {report-eval:Side Area}%data:Height% * %variable:Circumference%{report-eval} cm ^2^ ||
|| Total Surface Area | {report-eval}%variable:Side Area% + %variable:Base Area% * 2{report-eval} cm ^2^ ||
|| Total Volume | {report-eval}%variable:Base Area% * %data:Height%{report-eval} cm ^3^ ||
Radius | 10 cm |
|---|---|
Height | 30 cm |
Base Circumference | 62.83185307179586 cm |
Base Area | 314.1592653589793 cm 2 |
Side Area | 1884.9555921538758 cm 2 |
Total Surface Area | 2513.2741228718346 cm 2 |
Total Volume | 9424.77796076938 cm 3 |