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

OTBI Conditionl Formating

in Reporting and Analytics for HCM 2 comments

I’m facing an issue while building a formula in OTBI (Subject Area: General Ledger - Journals Real Time).

Requirement:

I want to calculate a value that combines:

  • Journal Total Accounted Debit (for specific Journal Sources: Manual, AutoCopy, Spreadsheet, Reversed Payable Journals)
  • Subledger Journal Line Accounted Amount DR and CR

My initial formula is working fine:

IFNULL((CASE WHEN "General Ledger - Journals Real Time"."Journal Source"."Journal Source Name"='Manual' OR "General Ledger - Journals Real Time"."Journal Source"."Journal Source Name"='AutoCopy' OR "General Ledger - Journals Real Time"."Journal Source"."Journal Source Name"='Spreadsheet' OR "General Ledger - Journals Real Time"."Journal Source"."Journal Source Name"='Payables' THEN "General Ledger - Journals Real Time"."Journal Line Amounts"."Journal Total Accounted Debit" END), 0)+IFNULL("Subledger Accounting - Journals Real Time"."Journals"."Journal Line Accounted Amount DR", 0)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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