Error in Set Modifier Expression

[#1]

Hello,

I am receiving an error for the following expression:

=Sum({1<CC_Date = {"$(='>=' & Date(WeekStart(Max(CC_Date)), 'M/D/YYYY') & '<=' & Date(WeekEnd(Max(CC_Date)), 'M/D/YYYY'))"}[Abandoned])

My goal is to show the sum of abandoned for the max week in the data.

[marcus_sommer]

Try this:

=Sum({1<CC_Date = {">=$(=Date(WeekStart(Max(CC_Date)), 'M/D/YYYY'))

                                      <=$(=Date(WeekEnd(Max(CC_Date)), 'M/D/YYYY'))"}>} [Abandoned])

- Marcus