#312 If procedure does not work

[Franziska Mewis]

SciDAVis Version: 1.18
Operating Sytem : Windows 7 Professional + SP1, 32Bit

Problem: if I want to use the if procedure to calculate a new column, it does not work. There is the same Error message, eachtime. It seems af if the if-Procedure don´t know its own syntax, because it generates an syntaxerror by using the parenthesis [if()].

[gbm]

The 'if' expression 'if (e1,e2,e3)' is deprecated in muParser since version 2.0.0.
Instead, you can use the if-then-else ternary operator '?:' that has a C++ style syntax:

e1 ? e2 : e3

Thus, your formula could be:

col("Ton[]") < 0 ? 0 : col("Ton[]")

or, alternatively

max(0, col("Ton[]"))