Categories
- All Categories
- Oracle Analytics Learning Hub
- 29 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 237 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 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
