Dear..
I am using this data
select data1.month,sum(data1.qty) as qty,sum(data1.weight) as weight,sum(data1.amount) as amount,max(data1.kgrt)as kgrt
from
(select month(date) as month,qty,qty * weight as weight,round(cr_amount/weight,2)as kgrt,cr_amount as amount from cashsalp
where type='P'
union all
select month(date) as month, qty,qty * weight as weight,round(cr_amount/weight,2)as kgrt,cr_amount as amount from crsalp
where type='P')
as data1
group by data1.month
In result, field kgrt is showing wrong data like
144577602/4183502=34.55
but is showing 40537.50
Please help