How to use "OR" as multiple numerator in set analysis

[Anonymous]

hello everyone,

Can someone pls help me on how to put "OR" for multiple criteria on numerator?

count(distinct If(

(STMD_TXN_EFF_DT >= UNSECSTARTDATE)

and Not wildmatch(TRTMNT_CD , '000000012802','000000012850'

),DIST_CIFNO))

OR

count(distinct If(

(STMD_TXN_EFF_DT >= UNSECSTARTDATE)

and match(UNSECTEAM, 'USAGE - TRAVEL','USAGE - RETAIL')

,DIST_CIFNO))

/

count(distinct If(

(BUSINESS = 'UNSECURED')

,DIST_CIFNO))

[sunny_talwar]

May be this

Count(DISTINCT If(STMD_TXN_EFF_DT >= UNSECSTARTDATE) and (Not WildMatch(TRTMNT_CD, '000000012802', '000000012850') or Match(UNSECTEAM, 'USAGE - TRAVEL','USAGE - RETAIL')), DIST_CIFNO))

/

Count(DISTINCT If(BUSINESS = 'UNSECURED', DIST_CIFNO))

[Anonymous]

It works!!! I've trying to solve this for a while now and with always no avail

Super thanks Sunny!!!