RollupAve based on condition

Question

Hi, 
 i need to calculate average amount of opportunities related to a project, but i need to consider only opportunities where "opportunity type" dropdown field is set to a defined value. Cannot find what to add to basic average function, anybody can help please? 
 rollupAve($osy_project_phases_opportunities_1,"average_value_c")

marco baracco · Answer

This specific sugarLogic formula doesn't exist, but you can achieve that calculation thru this formula: 
 
 divide(rollupConditionalSum($link,$field,$field_condition,"Field Value"),countConditional($link,$field_condition,createList("Field Value")))

marco baracco · Answer

You just need to implement a simple extended vardefs on Project module: 
 
 
$dictionary['Project']['related_calc_fields'][]='opportunity_link';

Regards