Error

[thiguiii]

Hi, I have one mistake in my formula, but I don't know what's the issue.

=num(sum({< SNAP_SHOT_DATE={'$(=[ReportDate])'}, [Status Code]={'1','2','3','4','5','6'} ,VALUE_CALENDAR_YEAR ={'$(=[Filteryear])'} ,DATETYPE = { 'A'}>}[Idea Sav at Confidence|DS0])/1000000
-sum({< SNAP_SHOT_DATE={'$(=(Max({<ReportDate={'$(='<'&(only(ReportDate)))'}>} ReportDate)))'}, [Status Code]={'1','2','3','4','5','6'} ,VALUE_CALENDAR_YEAR ={'$(=[Filteryear])'}
,DATETYPE = { 'A'}>}[Idea Sav at Confidence|DS0])/1000000,'0.$(vDecimalPlaces);(0.$(vDecimalPlaces))')

[BrunPierre · Accepted solution]

Maybe this?

SNAP_SHOT_DATE={'$(=(Max({<ReportDate={"<=$(=Only(ReportDate))"}>} ReportDate)))'}