1 Reply Latest reply: Jun 20, 2016 12:19 PM by Marcus Sommer RSS

    Error in Set Modifier Expression

    Linsey Kempton

      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.