Categories
Calculated column not giving values
Answers
-
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 " "
ENDHope you get to your solution soon.
Jon
0 -
Thanks for your input Jon, but unfortunately not the solution yet.
Also missing the IN after the NOT statement
Kind regards,
Maarten0 -
Thanks for your input Jon, but unfortunately not the solution yet.
Also missing the IN after the NOT statement
Kind regards,
Maarten0