Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If(DATE_TEMP = 'YTD',(count({<DEPARTMENT_CODE={'1230','25030','26048'},ENCOUNTER_TYPE_CLASS_CODE={'4'},REFERAL_IN_TYPE={'I'},DAY_DATE = {">=$(=Date(YearStart(AddYears(Max(DAY_DATE),0)),'DD/MM/YYYY'))<=$(=Date(AddYears(Max(DAY_DATE),0),'DD/MM/YYYY'))"},Year = ,Month =>}PATIENTID)),If(DATE_TEMP = 'QTD',(count({<DEPARTMENT_CODE={'1230','25030','26048'},ENCOUNTER_TYPE_CLASS_CODE={'4'},REFERAL_IN_TYPE={'I'},DAY_DATE = {">=$(=Date(QuarterStart(AddYears(Max(DAY_DATE),0)),'DD/MM/YYYY'))<=$(=Date(AddYears(Max(DAY_DATE),0),'DD/MM/YYYY'))"},Year = ,Month =>}PATIENTID)),If(DATE_TEMP = 'MTD',(count({<DEPARTMENT_CODE={'1230','25030','26048'},ENCOUNTER_TYPE_CLASS_CODE={'4'},REFERAL_IN_TYPE={'I'},DAY_DATE = {">=$(=Date(MonthStart(AddYears(Max(DAY_DATE),0)),'DD/MM/YYYY'))<=$(=Date(AddYears(Max(DAY_DATE),0),'DD/MM/YYYY'))"},Year = ,Month =>}PATIENTID)))))
I need to find internal referral during these period(YTD,QTD,MTD)
