2 Replies Latest reply: Jun 29, 2016 12:09 PM by Linsey Kempton RSS

    Text Box Expression to show last week Average - Error In Set Modifier


      I am experiencing an error in the set modifier for the following Text Element


      =num(Avg({1<CC_Date={">=$(=Date(WeekStart(Max(CC_Date), 'M/D/YYYY'))<=$(=Date(WeekEnd(Max(CC_Date)), 'M/D/YYYY'))"}>} ([FCR % (=>80%)])), '#.##%')


      My Date field is CC_Date

      And I want to who the average for the week prior of the field [FCR % (=>80%)]