Hi,
I have table
test_scoreAbsentExempt
20 NN
NA Y N ---Scenario 1
NA NY ---Scenario 2
Scenario:1
if test_score='NA' then
check 2nd column Absent if it is' Y' i want to use it and the below expression works.
test_score == "NA" ? Absent : test_score
i would like to know if i can add the 2nd scenario in the same expression
scenarion:2
if test_score='NA' then
check 2nd column Absent if it is ,'N' then
I need the 3rd column data as score .
Thanks in Advance