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

[#1]

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

[tamilarasu · Accepted solution]

Linsey,

Try this,

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

[#3]

Thank you!