Where

[system]

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)

[system]

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

Welcome to B B by the way

---

Andreas (BOB member since 2002-06-20)

[system]

@jorgelemos

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)

Try this

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

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

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 (BOB member since 2005-04-15)