Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to calculate an indicator whose objective is to calculate the Number of Findings still open 6 months after date of notification. So basically Each Findings, I have a closing date (CLOSE_DATE) and a notification date and I want to calculate the number of Findings that have a closing date than 6 months of their date of notification.
That's what I tried to do but it does not work :
Count ({$<CLOSE_DATE={">=$(=date(AddMonths(date_notification,6))"}>} DISTINCT FINDINGS_ID)
Thank you in advance.
it works. Now I just need to verify that my data are correct.
I come back to you if i have another problem.
Thank you very much.
you're welcome at anytime do not hesitate to ask me
Thank you very much.
I will try this method too, so I have two methods.
Hello,
When I add the set analysis, it does not work.
That's my expression :
Count({$<AUDIT_STATUS_ID<>{'3'} >} Distinct if(Close_date >=num(DayStart(AddMonths(date(date_notification),6))), FINDINGS_ID))
Thank you.
Sorry for the inconvenience. It works.
use the following in your set analysis
AUDIT_STATUS_ID ={"*"}-{3}