Case Dataitem <> Dataitem

[antexity]

Hi,

Not sure what I am missing.  the bellow formula is erroring out:

Error:

QE-DEF-0261 QFWP - Parsing text: CASE WHEN ([Tax Area PO HDR (PHTXA1)]<>[Tx Area VDR (A6TXA2)]) THEN ('Tax Area on PO doesn't match Vendor') ELSE ('GOOD') ENDQE-DEF-0260 Parsing error before or near position: 94 of: "CASE WHEN ([Tax Area PO HDR (PHTXA1)]<>[Tx Area VDR (A6TXA2)]) THEN ('Tax Area on PO doesn't"

Formula:


CASE
WHEN ([Tax Area PO HDR (PHTXA1)]<>[Tx Area VDR (A6TXA2)])

THEN ('Tax Area on PO doesn't match Vendor')

ELSE ('GOOD')

END

Any ideas?

Thanks so much

[RKMI]

Hi,

You have a single quote in doesn't which is throwing it off... change it to,

CASE
WHEN ([Tax Area PO HDR (PHTXA1)]<>[Tx Area VDR (A6TXA2)])

THEN ('Tax Area on PO does not match Vendor')

ELSE ('GOOD')

END

See if this works,


Thanks,
RK

[antexity]

lol,  That is it.  Completely missed the " ' "

Thanks Bud,
Jonathan

[RKMI]

Yeah, its a common parsing text issue.  ;)

Thanks,
RK