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
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
lol, That is it. Completely missed the " ' "
Thanks Bud,
Jonathan
Yeah, its a common parsing text issue. ;)
Thanks,
RK