Value set returns random responses on each run

I am using value set called Get_Late_Entries. The value set is of type table. The query written in values is being verified by BI Publisher.
My issue is that the value set either returns a blank value or 1 randomly. i have debugged it by following methods:
1. Passing no input parameters to the value set
2. Pass hard coded values from fast formula to value set
3. Write hard coded parameters in value set
4. Value set to simply return a static number without any where clause

— my value set code is :