Calculation field: Difference between revisions

Calculation field (view source)

5 bytes added , 4 December 2016

m

no edit summary

4,332

edits

@@ Line 97: / Line 97: @@
 ! Function !! Arguments !! Returns
 |-
-| '''if''' || expression<br/>value if TRUE<br/>value if FALSE || one value of a logical expression if TRUE (not equal to 0.0) and another if it is FALSE (equal to 0.0)<br/>For example, if(#{remaining} == 0, 'Done', 'Incomplete')
+| '''if''' || expression<br/>value if TRUE<br/>value if FALSE || one value of a logical expression if TRUE (not equal to 0.0)<br/>and another if it is FALSE (equal to 0.0)<br/>For example, if(#{remaining} == 0, 'Done', 'Incomplete')
 |-
-| '''switch''' || expression<br/> value/result pairs<br/> default result || the final result based on selecting among the paired results to identify the paired value (or else the default value) to be used.<br/>For example, switch(#{count}, 1, 'One', 2, 'Two', 'Many')
+| '''switch''' || expression<br/> value/result pairs<br/> default result || the final result based on selecting among the paired values to identify the paired result (or else the default result) to be used.<br/>For example, switch(#{count}, 1, 'One', 2, 'Two', 'Many')
 |}