Report Eval

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	(X)	NO		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	(X)	NO		An %injectable% value that will be used if the expression does not evaluate to a valid result.
format	(X)	NO		A number format to output the result with. e.g.: "#,##0.00".
hidden	(X)	NO	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.

CODE

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.