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!

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!

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):

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

3 Likes

Thanks @MartinDDDD! I will give this a try!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.