Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Marco,
Try the below expression:
=count({<Global_assunto = {'1'}, AUT_YEAR = , CAL_YEAR={ "<= $(=Max(AUT_YEAR))"} >}
DISTINCT (CODICE_AZDIP))