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 Case Statement excludes some of the row from Statements

Summary:


After adding Transaction code formula as follows

CASE

WHEN ("- Line Information"."Statement Line Transaction Code" = '165' AND "- Line Information"."Statement Line Addenda Text" LIKE '%BRAINTREE%') THEN '165B'

WHEN ("- Line Information"."Statement Line Transaction Code" = '165' AND "- Line Information"."Statement Line Addenda Text" LIKE '%AMERICAN%EXPRESS%') THEN '165A'

WHEN ("- Line Information"."Statement Line Transaction Code" = '191' AND "- Line Information"."Statement Line Addenda Text" LIKE '%HEI%') THEN '191H'

ELSE "- Line Information"."Statement Line Transaction Code"

END

some of the rows are not populating for example, Please check the Transaction code 164.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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