Examples of Calculated Fields in a Dynamic Template
Note that all expressions need to be enclosed in the following format:
Description | Expression |
|---|---|
Display status ID having alias A and values 0, 1, 2 to display Success, Warning and Error. | ${A == 0 ? 'Success' : A == 1 ? 'Warning' : 'Error'} |
Add two numeric fields A and B. | ${A + B} |
Calculate percentage A from A and B. | ${A / (A+B)} |
Convert from A which is in KB to GB. | ${A / (1024 * 1024)} |
Calculate duration by subtracting values of date fields | ${G.time - F.time} |