Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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))
It works!!! I've trying to solve this for a while now and with always no avail
Super thanks Sunny!!!