set analysis MONTH-1

[souadouert]

whe i used this expressioin

Sum( {<COMPTE_ENCOURS_TND={">0"} ,DATE_SITUATION= {"=MONTH(DATE_SITUATION) = '11'"}, COMPTE_TYPE_DEPOT={"DAV"},CLIENT_PRE_SOUS_SEGMENT_A,CLIENT_PRE_SEGMENT_A,CLIENT_PRE_SEGMENT_A={"HAUT DE GAMME"}>} COMPTE_ENCOURS_TND)

i have the correct resultat , and when i want make this expression dynamic
Sum( {<COMPTE_ENCOURS_TND={">0"} ,DATE_SITUATION= {"=MONTH(DATE_SITUATION) = $(=MAX(MONTH(DATE_SITUATION))-1) "}, COMPTE_TYPE_DEPOT={"DAV"},CLIENT_PRE_SOUS_SEGMENT_A,CLIENT_PRE_SEGMENT_A,CLIENT_PRE_SEGMENT_A={"HAUT DE GAMME"}>} COMPTE_ENCOURS_TND)

i have 0 as result

[souadouert]

ewemple 20171203

script

DATE(DATE_SITUATION,'YYYYMMDD') as DATE_SITUATION

[sunny_talwar]

This is helpful, but can you also post a screenshot of DATE_SITUATION in a list box object

[souadouert]

[sunny_talwar]

Can you add this expression in a text box object and post another screenshot

=Max(DATE_SITUATION) & Chr(10) & Max(Month(DATE_SITUATION)) & Chr(10) & Max(Year(DATE_SITUATION))