Column Expression: If statement with and

[AnotherFraudUser]

Hi @ahortonmilsig

Here is a good example for the if syntax

How to use if expressions in a column expressions node

Hi, sorry that I missed this post concerning the Column Expressions node. In another thread (see here) I broke down the syntax of the Column Expressions and Variable Expressions node and how to use it. I’ve already mentioned that it is possible to use loops (for, while) and if-else statements. As previous posts already mentioned, you have the following syntax: if(**state**) { // do this, if **state** evaluates to true } else { // do that, if **state** evaluates to false } So this is…

Cannot test it at the moment, but your example should be something like this:

if(column(“2019 revenue”) > 0.0 && column(“2018 revenue”) = 0)
{
1
}
else {
round((column(“2019 revenue”)-column(“2018 revenue”))/column(“2018 revenue”),3)
}