Custom Expression including document property not working

[Kom Son]

Hello,

I'm trying to create a new column that populates the values in [clothing_type] column only if the value is equal to the selected value in the document property ${clothing_typeselector} if not, it should leave empty or 0.

The data type for all is string but I've tried casting to real with no luck.

I have this expression that returns the following error;

error: "The expression is not valid after 'then' on line 2"

expression:

case

when [clothing_type] = ${document property for the clothing_type column} then [hobby]

else 0

END

Please how can I resolve this

[Fabian Duerr]

Please use:

case

when [clothing_type] = DocumentProperty("name.of.your.doc.property") then [hobby]

else NULL

endAnd make sure that your else statement contains the same data type. I guess [hobby] holds strings. So, you want to return NULL or "0" but not 0