Equation Issue!!

[#1]

Hi Community

Can anyone see anything wrong with this expression?

=if(vcomp='function' and count(if(Function='Direct Marketing',Function and S1IndOrg='Ind', S1IndOrg))<5 and vchart=3,1,0)

Trying to use this to in a show condition, if the count of direct marketing and the count of S1IndOrg is less than 5, and if vchart is 3 and if vcomp = function, the object should delete off, it doesn't though!

Any ideas?  have pondered using set analysis, though don't see why this wont work.

The underlined part above = 2, and the other parameters are true!

Any ideas would be greatly appreciated

Thanks

Peter

[MarcoWedel · Accepted solution]

plese post sample app/data to test your expression with

regards

Marco

[#3]

Marco, thanks for the response

Got it sorted, capital grammar mistake on 1 of the variables, sorry!

Its 11 O'clock here in Belfast, been looking at this screen for way to long

Thanks

Peter

[MarcoWedel]

Hi Peter,

glad you got it.

Good night

Marco