Error in expression Count takes 1 parameter...

[jmarinesc]

Hello;

I have an error expression..but I don´t find it...pleae help me on this....tk in advanced. (Maybe is in bold Exp..)

Error in expression:
Count takes 1 parameter

LOAD
remision
,if(count(remision)=1 ,-1)as "NoMatch"
,if(count(remision)>=2,-2)as "SiMatch"
,if(maxstring(idestacion)<>minstring(idestacion),-4) as "DifEstacion"
,if(max(vnatural)<>min(vnatural),-5)as "DifLitros"

,if(maxstring(idproducto)= minstring(idproducto),-7)as "IgDesc"

,if(count(remision)>=2 and (maxstring(idproducto)=minstring(idproducto)),-1) as "NoMatch1"
,if(count(remision)>=2 and (count(distinct(idproducto)=1,-1))) as "NoMatch2"

Tk QCommunity!

[MayilVahanan · Accepted solution]

HI

if(count(remision)>=2 and (count(distinct idproducto))=1,-1) as "NoMatch2

And did u use group by too??

Hope it helps

[jmarinesc]

Tk! 

It works.. yepppppp!