Apache OpenOffice Community Forum

Posted: **Fri Aug 07, 2020 11:16 pm**

Hi all,

Having a slight problem with a CASE statement. I need to show either the value of the acttax or tinclusive fields based on the value of the TaxRate field.

I am using the following code which produces an error and I can not figure out the message...

Code: Select all

SELECT "jobid",
        "TaxRate",
		"acttax",
		"tinclusive",
        CASE
           WHEN "TaxRate = 0 THEN "tinclusive"
           ELSE "acttax"
        END as "offset"
 FROM "ccTaxes"

Anyone spotting my mistake ? Thank you

Posted: **Sat Aug 08, 2020 12:29 am**

I think you have a missing a double quote after TaxRate. Try

Code: Select all

SELECT "jobid",
        "TaxRate",
      "acttax",
      "tinclusive",
        CASE
           WHEN "TaxRate" = 0 THEN "tinclusive"
           ELSE "acttax"
        END as "offset"
FROM "ccTaxes"

Posted: **Sat Aug 08, 2020 2:59 am**

@FJCC

Thanks, am going blind, so obvious!

Apache OpenOffice Community Forum

[Solved] Conditional field value SQL (CASE)

[Solved] Conditional field value SQL (CASE)

Re: Conditional field value SQL (CASE)

Re: Conditional field value SQL (CASE)