Dears Sirs,
Im 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)
Dears Sirs,
Im 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 B by the way
Andreas (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.
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)