PB DATE

[#1]

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.

[#2]

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.

[ali_hijazi]

you're welcome at anytime do not hesitate to ask me

[#4]

Thank you very much.

I will try this method too, so I have two methods.

[#5]

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.

[#6]

Sorry for the inconvenience. It works.

[ali_hijazi]

use the following in your set analysis

AUDIT_STATUS_ID ={"*"}-{3}