how it works in Set Analysis symbol less than and greater than equal?

[Anonymous]

hi    

how it works in Set Analysis symbol less than and greater than equal?

this function

=count({<Global_assunto = {'1'}, CAL_YEAR={$(=Max(AUT_YEAR))}, AUT_YEAR = >} DISTINCT CODICE_AZDIP)

this no. I added the symbol <= before Max(AUT_YEAR)

=count({<Global_assunto = {'1'}, CAL_YEAR={$(<=Max(AUT_YEAR))}, AUT_YEAR = >} DISTINCT CODICE_AZDIP)

tanks

[israrkhan]

Hi Try like below:

=count({<Global_assunto = {'1'}, CAL_YEAR={<=$(=Max(AUT_YEAR))}, AUT_YEAR = >} DISTINCT CODICE_AZDIP)

or

=count({<Global_assunto = {'1'}, CAL_YEAR={"<=$(=Max(AUT_YEAR))}, AUT_YEAR = >"} DISTINCT CODICE_AZDIP)

or

=count({<Global_assunto = {'1'}, CAL_YEAR={'<=$(=Max(AUT_YEAR))}, AUT_YEAR = >'} DISTINCT CODICE_AZDIP)

Note, If your field [Global_assunto] is integer then dont put like {'1'},

write like [Global_assunto] = {1}..

Hope it helps

[#3]

Hi Marco,

Try the below expression:

=count({<Global_assunto = {'1'}, AUT_YEAR = , CAL_YEAR={ "<= $(=Max(AUT_YEAR))"} >}

DISTINCT (CODICE_AZDIP))