If condition in calculation

[Data_consumer]

Hi!

Is there a way to use the math formula node to do conditional calculations? What I’m trying to do is the following:

if(COL_SUM($Value$)=NULL,0 ,(COL_SUM($Value$))

What is the correct syntax for this?

Thanks!

[MartinDDDD]

Can you provide some data with an example?

In general I think Math Formula Node cannot do this: It is not supporting (by default) if conditions and also cannot do column sums.

I think your best bet is to try out the new Expressions Node (available with V5.3):

Expression

You can find IF syntax under conditions, column_sum under Math - Aggregate columns and MISSING under Constant Category:

[Data_consumer]

Thanks @MartinDDDD! I will give this a try!