Case Formula

Question

Hi

What is my error in this Case formula

CASE

WHEN "Nature contrat (contrat publié).Code nature contrat" = AP THEN 'Approvisionnement'

WHEN  "Nature contrat (contrat publié).Code nature contrat" = SS THEN 'Services'

ELSE Travaux de construction

END

Thanks

Gianni Ceresa · Answer

There are a few ...

You aren't referencing any column, because a presentation column should at least have the format "presentation table"."presentation column".

You are comparing to AP and SS: you must define them as static strings with quotes.

Same apply to your Travaux de construction, that should be a static string with quotes.

And for more, post the error you get and the product name and version.