Column Expression: If statement with and

[ahortonmilsig]

I have 2 columns of data: 2018 sales and 2019 sales. I am using column expressions node to determine growth rate …round((column(“2019 revenue”)-column(“2018 revenue”))/column(“2018 revenue”),3)

I would also like to add an IF statement but I can’t figure out how to write it correctly…

if column(“2019 revenue”) > 0.0 AND if column(“2018 revenue”) = 0 then “1”
if else put growth rate calculation round((column(“2019 revenue”)-column(“2018 revenue”))/column(“2018 revenue”),3)

How do I write this in the Column Expressions node?

[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)
}

[AnotherFraudUser]

*tested now: should be == instead of =

The following works for me:
if(column(“2019 revenue”)> 0.0 && column(“2018 revenue”) == 0)
{
1
}
else {
round((column(“2019 revenue”)-column(“2018 revenue”))/column(“2018 revenue”),3)
}

[ahortonmilsig]

Thank you so much, I really appreciate it.