Variable:Not Like '3%'

system · September 14, 2009, 8:18pm

Hi All,
I need to create a variable

Dim_Acct.Account NOT LIKE ‘3%’

Need help as to how I create this in Webi.

GNK_BO (BOB member since 2007-07-17)

system · September 14, 2009, 8:49pm

Look at the Match() function to use wildcards in variables (or formulas) in a report.

Dave Rathbun (BOB member since 2002-06-06)

system · September 14, 2009, 9:04pm

Hi Dave,
Thanks for your reply.
Yes I found that and created the variable what I wanted Dim_Acct.Account NOT LIKE ‘3%’

Not(Match([Account];"3*"))

Thanks again.

GNK_BO (BOB member since 2007-07-17)