Error in Set Modifier Expression

Mon, 20 Jun 2016 15:54:53 GMT

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.

Re: Error in Set Modifier Expression

marcus_sommer — Mon, 20 Jun 2016 16:19:44 GMT

Try this:

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

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

- Marcus