Hi everybody,

I do not know if there is a standard check box somewhere to do this but since a few days I am looking for how to have the pipeline charts of SugarCRM 4.0 showing opportunities amounts balaced with the opportunities probability.

For our business it is more usefull to show the pipeline like this than to add amounts that should not be added with each-other.

To make this happen I have changed SQL request in the following files :
Chart_pipeline_by_sales_stage.php
Chart_my_pipeline_by_sales_stage.php
located in /modules/Charts/code

The new SQL request I use is :

$query = " SELECT opportunities.sales_stage, opportunities.probability,
users.user_name,
opportunities.assigned_user_id,
count( * ) AS opp_count,
sum(probability * amount_usdollar/100000) AS total
FROM users,opportunities ";

And then I give me the Pipeline with the balanced figures.

If there is a standard or easiest way to do this :
1- feel free to lauft at me
2- thank to give it to me

Thank Sugar for this FANTASTIC tools.

Bye

FX Beorchia
from Paris France
fx@invarture.com