RollupAve based on condition

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")

Parents

0 André Lopes over 3 years ago

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")))

André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Vote Up +3 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 marco baracco over 3 years ago in reply to André Lopes

Thanks André, one more point, is this formula supposed to work even if fields to be summed are calculated fields themselves?
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 André Lopes over 3 years ago in reply to marco baracco
You just need to implement a simple extended vardefs on Project module:

$dictionary['Project']['related_calc_fields'][]='opportunity_link';

Regards
André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Reply

0 André Lopes over 3 years ago in reply to marco baracco
You just need to implement a simple extended vardefs on Project module:

$dictionary['Project']['related_calc_fields'][]='opportunity_link';

Regards
André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Children

No Data