IF() Funktion used in Report
Posted: Wed Dec 15, 2021 4:00 pm
Hello
i would like to use a IF() Function inside a report, to translate a table made of 1 and 0 into Yes and No. I tried using aliases in the table.
Unfortunatly
is not working while
is working fine, when using a field calles 'word' inside the report.
How could I achieve my goal?
Best regards
marcus
i would like to use a IF() Function inside a report, to translate a table made of 1 and 0 into Yes and No. I tried using aliases in the table.
Unfortunatly
Code: Select all
SELECT IF(test_data = 1, "Yes, "No") AS word FROM table_testCode: Select all
SELECT test_data AS word FROM table_testHow could I achieve my goal?
Best regards
marcus