Count if / avg if

[Maciej29]

I have a question, as i have no idea why this formula doesn't work properly :

avg({<[Date Verified]={'>=$(=WeekStart(Today()-7))<=$(=Date(WeekEnd(Today()-7)-1))'}>}[KPI])

I would like to get average KPI  for last week (last 5 working days), based on date verified. Only formula, no script version because i'm not familiar with it.

Much appreciate if anyone can help.

[Vegar · Accepted solution]

It could be your single quotes. Try using double quotes in your set modifier. Like this :

avg({<[Date Verified]={">=$(=WeekStart(Today()-7))<=$(=Date(WeekEnd(Today()-7)-1))"}>}[KPI])

[Maciej29]

... easier than i thought.  Thanks a lot !

Could you please clarify what the difference is between single and double quotation ? I thought it's all the same..