Hi,

Could i use if else statement in data processing of CalculatedColumn? Example:

if ('variable1' == '0')
{ 
    'new_variable'=1;
}
else
{
    'new_variable'='variable2'/'variable3'*100;
}

Hi,

I have done the below for nested if else statement.

->pipe(new CalculatedColumn(array(
            "a"=>"({target}+{amount}=='0')?0:({target}=='0')?100:{amount}/{target}*100",
        )))

However, I still get an error message: Division by zero, although it is stated clearly that if target + amount = 0, then 0.

Where did I do wrong?

Appreciate your help.

Thank you very much.

Yes, it works.

Thanks a lot.