Wildcard

system · December 7, 2011, 8:44pm

Afternoon,

Is it possible to use a wild card within a business objects formula? for example…

[Party#] is a measure that has values 3331,3332,3334,321

If I made a variable that said =[Party#]=“333%” shouldn’t it return (be true) 3331,3332 and 3334?

Thanks!

arkiekeeper (BOB member since 2011-08-09)

system · December 7, 2011, 9:02pm

It is possible to use * as a wild card in a formula, for example the formula below which looks for any [Bill to] with the words Wal-Mart in it.

=IF(match([Bill to]; "Wal-Mart) then …

Teron (BOB member since 2011-11-09)

system · December 7, 2011, 10:13pm

it must not work with numeric…I get a data type error and my measure is a numeric data type. Weird? Thanks for the help. anyone else?

arkiekeeper (BOB member since 2011-08-09)

system · December 8, 2011, 12:15am

Try Where ([Party#]>3330)

Madduri (BOB member since 2007-02-15)

system · December 8, 2011, 10:35am

True, wildcards like % and * only work for strings. For numbers, you’ll need to use >< >=<= instead. This isn’t just in Business Objects btw, but in pretty much any application I know.

Binabik

pderop (BOB member since 2010-10-27)

system · February 21, 2012, 5:35pm

Thanks to Teron, I got this to work. Here is my variable’s formula, perhaps it can help someone else:

=If(Match([Status]; "Closed*") Or Match([Status]; "Cancelled*") Or Match([Status]; "Cancelled*")) Then [Count Distinct SRs]

Or to achieve opposite results:

=If(Match([Status]; "Closed*") Or Match([Status]; "Cancelled*") Or Match([Status]; "Cancelled*")) Then 0 Else [Count Distinct SRs]

Mr. B (BOB member since 2011-08-25)