Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the formula below and would like only to show the results for the current month, cant see to get it to work.
=
(Sum(If(InterviewCompletedBy=[FLA ID-pas], 1, 0)))
/
(count(Access_Number)+(Count(CaseNum)-count(Access_Number)))
Thank you.
Hi @danieldors here you have another idea, with set analysis considering avoid selections of Year and Month, and set to current month, or period, please try something like this :
=
(Sum({< Year =, Month = , Period = {'$(=monthname(today()-1))'} >} If(InterviewCompletedBy = [FLA ID-pas], 1, 0)))
/
(count({< Year =, Month = , Period = {'$(=monthname(today()-1))'} >} Access_Number)+(Count({< Year =, Month = , Period = {'$(=monthname(today()-1))'} >} CaseNum)-count({< Year =, Month = , Period = {'$(=monthname(today()-1))'} >} Access_Number)))
May be like this:
=
(Sum({<Month={'$(=max(Month))'}>}If(InterviewCompletedBy=[FLA ID-pas], 1, 0)))
/
(count({<Month={'$(=max(Month))'}>}Access_Number)+(Count({<Month={'$(=max(Month))'}>}CaseNum)-count({<Month={'$(=max(Month))'}>}Access_Number)))
Thanks,
Priyanka
Hi @danieldors here you have another idea, with set analysis considering avoid selections of Year and Month, and set to current month, or period, please try something like this :
=
(Sum({< Year =, Month = , Period = {'$(=monthname(today()-1))'} >} If(InterviewCompletedBy = [FLA ID-pas], 1, 0)))
/
(count({< Year =, Month = , Period = {'$(=monthname(today()-1))'} >} Access_Number)+(Count({< Year =, Month = , Period = {'$(=monthname(today()-1))'} >} CaseNum)-count({< Year =, Month = , Period = {'$(=monthname(today()-1))'} >} Access_Number)))
It did work thank you.