round(cr_amount/weight*qty,2) as kgrt

When a calculation is "wrong", it is often a good idea to compare the wrong result with the correct one by multiplying, dividing, adding or subtracting the two values. The difference will often make you realize what's the mistake.

>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