Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
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])
... 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..