sqlcurious
asked on
Help needed in stored proc
hi experts
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
sample-output-project-detail-cos.txt
reportdetailcost.txt
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
sample-output-project-detail-cos.txt
reportdetailcost.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i need to develop the report based on the stored proc. I have attached the report sample .
My question is
i have to calculate total bid price=sum of all total price in the project.
For example in my attached report
My total bid price=total project=24.96+35.04+10+21=
how to implement this in the above procedure.
rpteBidProjectDetailCosting1.pdf