Not getting the exact data by using ANC_ABS_ENTRS_ABSENCE_STATUS_CD = 'SCHEDULED'

Summary:

While using the ANC_ABS_ENTRS_ABSENCE_STATUS_CD = 'SCHEDULED' we want to count all the scheduled absence from 1 jan to 31 dec but when we are using ANC_ABS_ENTRS_ABSENCE_STATUS_CD = 'SCHEDULED' this it is counting and throwing null value.

While using ANC_ABS_ENTRS_ABSENCE_STATUS_CD = 'SUBMITTED' it i counting scheduled but as well as Completed also

i tried many methods even 'COMPLETED' is also not working

so how to count the Scheduled Absence only

Ref- all lookups values of Absence Status in the Absence Record Page Stores in the lookup type "ANC_PER_ABS_ENT_DISPLAY_STATUS"