Data for Current Month

[danieldors]

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.

[PriyankaShivhare]

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

[QFabian · Accepted solution]

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

[danieldors]

It did work thank you.