Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

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

Calculated column not giving values

Received Response
301
Views
13
Comments
2»

Answers

  • Jonathan Chan gmg
    Jonathan Chan gmg 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
     

  • MaartenDIF
    MaartenDIF 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

  • MaartenDIF
    MaartenDIF 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