Calculation field: Difference between revisions

Calculation field (view source)

1 byte removed , 4 December 2016

m

no edit summary

4,332

edits

@@ Line 99: / Line 99: @@
 ! Function !! Arguments !! Returns
 |-
-| '''if''' || expression<br/>value if TRUE<br/>value if FALSE || 3 arguments<br/>one value if a logical expression is TRUE (not equal to 0.0)<br/>and another if it is FALSE (equal to 0.0)<br/>Read it as "If expression is true, then value 1, else value 2"<br/>Example: if(#{remaining} == 0, 'Done', 'Incomplete')
+| '''if''' || expression<br/>value if TRUE<br/>value if FALSE || 3 arguments<br/>One value if a logical expression is TRUE (not equal to 0.0)<br/>and another if it is FALSE (equal to 0.0)<br/>Read it as "If expression is true, then value 1, else value 2"<br/>Example: if(#{remaining} == 0, 'Done', 'Incomplete')
 |-
-| '''switch''' || expression<br/> value/result pairs<br/> default result || 1+(2*#pairs)+1 arguments<br/>the final result based on matching the expression against the paired values to identify the paired result (or else the default result) to be used.<br/>Example: switch(#{count}, 1, 'One', 2, 'Two', 'Many')
+| '''switch''' || expression<br/> value/result pairs<br/> default result || 1+(2*#pairs)+1 arguments<br/>The final result based on matching the expression against the paired values to identify the paired result (or else the default result) to be used<br/>Example: switch(#{count}, 1, 'One', 2, 'Two', 'Many')
 |}