Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Case Formula

Received Response
11
Views
1
Comments
User_I0GH4
User_I0GH4 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:07PM in Oracle Analytics Cloud and Server

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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.