Calculated field - logical operator

[mferguson]

Does anyone know if it is possible to implement a logical operator (i.e. an if/then statement) within a calculated field? It doesn't seem to accept it right now.

Alternatively, is there any way for an HTML block to be configured to display a new field that displays the result of an if/then statement?

[Aariel]

hi,

If you want to display something in Calculated field, The statement to use is:

Case

when

then

else

end.

For example:

CASE

WHEN [@field:FIELDNAME1]="Value to compare"

THEN 0

ELSE [@field:FIELDNAME2]

END

where, FIELDNAME1 is the name of the field that you want to use in this comparision. FIELDNAME2 is the second field name that is used if the condition do not satisfy.

Hope this helps.

[mferguson]

That works great Aariel! Perfect solution.

[ParkLoey]

Hi! Just wanted to drop Caspio's function reference article here as well for everyone's reference when creating calculations such as making CASE statements:

https://howto.caspio.com/function-reference/