Differences

This shows you the differences between two versions of the page.

--- syntax:start [2015/02/01 14:39] – [Field names] dmitry
+++ syntax:start [2015/05/19 19:37] – [Parameters (starting from ver.1.6)] dmitry
@@ Line 14: / Line 14: @@
 Field names are case sensitive -- i.e. [Total], [TOTAL] and [total] are 3 different field names.
+==== Parameters (starting from ver.1.6) ====
+An expression can refer to [[parameters:|project parameters]] that are evaluated to text or number constants prior to calculating the expression. Parameter names in expressions are wrapped in curly brackets and are case-sensitive. E.g. {File name}, {Ratio}.
 === Example 1 ===
@@ Line 32: / Line 35: @@
 Let's assume we want to calculate new field 'Total Tax' using the following expression:
-  [Amount] * if( [Province]='QC', 13.5, 12.5) / 100
+  [Amount] * if( [Province]='QC', 13.5, 12.5) / 100 * {Multiplier}
+Where parameter {Multiplier} is 1.
 Resulting table:
 ^Province  ^Amount  ^Total Tax  ^
@@ Line 45: / Line 50: @@
   * [[transformations:rule|Rule]]
   * [[transformations:filter|Filter by condition]]
+  * [[transformations:trimbycondition|Trim by condition]]