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.