Set analysis with string function

[souadouert]

HELLO

I didn't found the error in this expression :

=count({<DATE={'<= $(DATE_EXT)'}, DATE_OUVERTURE = {'=RIGHT(DATE_OUVERTURE,2)) = RIGHT($(ANNEE_EXTRACTION),2) '}>}id)

[Anonymous]

hi

at first it seems to me that there is something missing in the highlighted part of the expression.

=count({<DATE={'<= $(DATE_EXT)'}, DATE_OUVERTURE = {'=RIGHT(DATE_OUVERTURE,2))

= RIGHT($(ANNEE_EXTRACTION),2) '}>}id)

[tresesco]

Not seeing an error (rather, an error highlighting), doesn't guarantee that the expression would give you expected output. It only indicates that, in someway the expression could be parsed to a a valid syntax. And to identify why your expression not working per se, would require more information. Could you share a sample file?

[sunny_talwar · Accepted solution]

May be these few things

1) Don't have space between >= and your dollar sign for set modifier for DATE

2) Use double quotes for search strings

3) May be you need an equal sign for the dollar sign expansion

=Count({<DATE = {"<=$(=DATE_EXT)"}, DATE_OUVERTURE = {"=Right(DATE_OUVERTURE, 2)) = Right($(ANNEE_EXTRACTION), 2)"}>} id)

or this

=Count({<DATE = {"<=$(=$(DATE_EXT))"}, DATE_OUVERTURE = {"=Right(DATE_OUVERTURE, 2)) = Right($(ANNEE_EXTRACTION), 2)"}>} id)