Calculated column not giving values

Jonathan Chan gmg

Hello Marteen,

Do the the data output the intended result with the following code?

CASE
WHEN "Payables Payments - Payment History Real Time"."- Payment Information"."Payment Status" IN ('Cleared','Negotiable','Voided')
THEN "Payables Payments - Payment History Real Time"."- Payment Information"."Payment Status"
WHEN "Payables Payments - Payment History Real Time"."- Payment Information"."Payment Status" NOT ('Cleared','Negotiable','Voided')
THEN "Payables Invoices - Transactions Real Time"."- Reference Information"."Payment Status Name"
ELSE " "
END

Hope you get to your solution soon.

Jon
 

MaartenDIF

Thanks for your input Jon, but unfortunately not the solution yet.

Also missing the IN after the NOT statement

Kind regards,
Maarten

MaartenDIF

Thanks for your input Jon, but unfortunately not the solution yet.

Also missing the IN after the NOT statement

Kind regards,
Maarten