Hi All,
I am using CASE FUNCTION, to retrieve data from a subject area.
The command is:
CASE "Candidate Q&A"."Question Code" WHEN 'R3 questionnaire 3' THEN "Candidate Q&A"."Answer (Choice) (BL)" END
Results show the correct data plus a line with null value.
I'd like to show only the value not null.
Is it possible using CASE function or other function? I tryied to use FILTER function, but this function doesn't work how I want.
Thanks!
Carlos.