BusinessObjects Board


Dears Sirs,

I’m trying to make the formula below (select more than one value for cod), but the result is syntax error. How can I do this?

= where (=1101,1102,2255)

jorgelemos (BOB member since 2006-08-21)

Please, do take a look at the Reporter FAQ here first.

Welcome to B :mrgreen: B by the way :slight_smile:

Andreas :de: (BOB member since 2002-06-20)

Try this

= If <cdg> inlist("1101", "1102", "2255") then <revenue>

you can’t select more than one value by using where clause.

the other workaround is
create a variable

=If <cdg> inlist("1101", "1102", "2255") then 1 else 0 

then use this formula

=<revenue> where (<flag> =1)

kool :nepal: (BOB member since 2005-04-15)