Hi want to build a report and need to add extra column called margin %by using following formula in the stored proc.I have attached the sample output of the proc and stored proc
the markup percent is taken directly from the column .Now i want to implement it using procedure similarly for total freight too.
i want additional margin column which has following formula
margin=(total bid price)-(sum of total cost)-(total base freight)/(total bid price)*100
where total base freight=total freight
and sum of total costs=total costs
sum of total price=total bid price