If statement help

[fostc80857]

Hi

I have tried the following if statement in the column expression node and it is not giving me the result I am after.

For the “Trade Effluent” rows the result is ‘infinity’ rather than the ‘volume’ amount as required. Example extract shown:

Where am I going wrong?

Thanks
Chris

[ipazin]

Hello @fostc80857,

Column Expressions node doesn’t stop evaluating conditions if one is true. It continues and outputs last - in your case probably else. To solve it and have it as one statement only the first condition should be if others should be else if.

Take a look at example here:

If Else in Column Expression – ipazin

Br,
Ivan