I have three separate SQL queries and I'm trying to divide but my results =0. It should = 100.
select sum(cast(measurement as int)) AS KPIValue select sum(AssetStatusHistory.DownTime) AS KPIValue
From WOTask From AssetStatusHistory
inner join wo on wo.wopk=WOTask.wopk LEFT JOIN Asset on Asset.AssetPk =
Measurement NOT LIKE '%[^0-9]%' RESULT = 0
RESULT = 2130
So I subtract SQL 1 from SQL2 then divide by SQL1 *100 which should give me 100%