Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
plese post sample app/data to test your expression with
regards
Marco
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
Hi Peter,
glad you got it.
Good night
Marco