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

    Linsey Kempton

      Hello,

      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%)]