Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Calculated column not giving values — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Calculated column not giving values

Accepted answer
edited Jun 2, 2020 2:05PM in General Transactional Reporting (OTBI) 13 comments


I'm creating an AP dashboard where I want to combine the subject areas for AP invoices and payments to show in a single column whether an invoice is paid/unpaid and the payment is cleared/negotiable.

The logic should be as follows:
IF Payment Status is null, THEN Invoice Payment status, ELSE Payment Status

My OTBI code is as follows:
CASE WHEN "Payables Payments - Payment History Real Time"."- Payment Information"."Check Status lookup Code" is null THEN "Payables Invoices - Transactions Real Time"."- Reference Information"."Payment Status Name" ELSE "Payables Payments - Payment History Real Time"."- Payment Information"."Payment Status" END

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!