CE_CALC if function

[former_member572313]

Hi Team,

I'm trying to use nested if condition using CE, below is my formula

CE_CALC(' if "Field1" = 0, 0, if "Field2" > "Field3", ( ("Field2" - "Field3") * "Field4" * -1 ), 0 ) ', DECIMAL(17,3)) AS "V_TEMP"

it is not returning the correct result. When I use the same condition in SQL Script, it is working fine. Is it possible to use nested if using CE function?

Thanks

Sathish

[former_member182114 · Accepted solution]

Hi Sathish,

If aren't being used correctly due to missing parenthesis.

CE_CALC(' if("Field1" = 0.0, 0.0, if("Field2" > "Field3", ( ("Field2" - "Field3") * "Field4" * -1 ), 0.0 )) ', DECIMAL(17,3)) AS "V_TEMP"

Also use 0.0 instead 0 as it's a decimal field and you avoid implict conversions.

Regards, Fernando Da Rós

[former_member572313 · Accepted solution]

Hi Fernando, Thanks, using 0.0 instead of 0 resolved the issue. Thanks much for your help!

BR,

Sathish