Hi,

I've to edit a JRS query manually to find date difference. The value of date difference is a numeric variable type. I've casted it to numeric and considered choosing numeric/integer value from variable type once I've to execute the query. But each time the query is executed the variable type value is reassigned to date and time in the 'Format as Table' section. 

I need to have this custom created field (by editing the query manually) to have a numeric/integer data type to populate the field in graph format against workitems. Any help in this regard would be highly appreciated. Below is my query for reference:

SELECT DISTINCT T1.NAME,

       T1.CREATION_DATE,

       T1.DUE_DATE,

               T1.CLOSED_DATE,

       case when T1.CLOSED_DATE is null then getdate() else T1.CLOSED_DATE end as closed_date,

       cast(

       case when (T1.CLOSED_DATE is null) then cast( (cast(DATEDIFF(day,T1.DUE_DATE,getdate())as decimal(4,2))/cast(DATEDIFF(day,T1.CREATION_DATE,T1.DUE_DATE) as decimal(4,2)))*100 as  numeric)

       else cast(cast(DATEDIFF(day,T1.CLOSED_DATE,T1.DUE_DATE) as decimal(4,2))/cast(DATEDIFF(day,T1.DUE_DATE,T1.CREATION_DATE) as decimal(4,2)) *100 as numeric) end

        as numeric)

       AS Project_Schedule_Variance

FROM RIDW.VW_REQUEST T1

WHERE T1.PROJECT_ID = 0  AND

(  T1.REQUEST_TYPE = 'Change Request' 

)  and  T1.CREATION_DATE>0 and

       T1.DUE_DATE>0 and

     DATEDIFF(day,T1.CREATION_DATE,T1.DUE_DATE)>0 and

(T1.ISSOFTDELETED = 0) AND

(T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL)