1
EXISTS (SELECT 1 FROM Common.Com_macss_Account a WHERE COM_MACSS_PREMISE.prem_nb = a.prem_nb AND a.ACCT_TYPE_CD  IN  ('E', 'EO') )

The above expression is in BO(Universe). Need to write it in cognos FM (Filetr). Tried CASE statement but didn't help.

Billal Begueradj
  • 20,717
  • 43
  • 112
  • 130
Maggie 14
  • 11
  • 1

0 Answers0