Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Calculated column not giving values

Received Response
241
Views
13
Comments
2»

Answers

  • Rank 5 - Community Champion

    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
     

  • Rank 4 - Community Specialist

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

    Also missing the IN after the NOT statement ;)

    Kind regards,
    Maarten

  • Rank 4 - Community Specialist

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

    Also missing the IN after the NOT statement ;)

    Kind regards,
    Maarten

Welcome!

It looks like you're new here. Sign in or register to get started.