Report - how to get decimal result
Anyone tell me what is wrong with this query please.
All I get are integer answers
If the count(*) returns 100 I'd expect the answer 1, if 200 it should be 0.5
What I get in all cases is the integer result only.
Tried a CAST (count(*) as real) for instance and that resulted in a blank result!
Tried this in V7022 and have a MS SQL 2005 backend
Regards,
Andy
All I get are integer answers
Select (100 / count(*) ) as Totals from workorder WO INNER JOIN RequestCharges rc ON wo.WORKORDERID=rc.WORKORDERID where
(((wo.COMPLETEDTIME >= <from_lastmonth>) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL))) AND ((wo.COMPLETEDTIME <= <to_lastmonth>) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL))))
If the count(*) returns 100 I'd expect the answer 1, if 200 it should be 0.5
What I get in all cases is the integer result only.
Tried a CAST (count(*) as real) for instance and that resulted in a blank result!
Tried this in V7022 and have a MS SQL 2005 backend
Regards,
Andy