Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Case Formula

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
Answers
-
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.
0