Trying to create a rollupAve of a number, where it doesn't count fields that are empty?

In order to do that you would need to create a custom rollupAve sugarLogic formula which suppress empty values.

Regards

Hi Jessica Taggart,

One way this can be handled with calculated fields:

Make a new checkbox in the module that has the avg_speaker_score_c field. Name the field "is_avg_populated_c". Put this calculation in that field:

greaterThan(strlen(toString($avg_speaker_score_c)),0)

Then, in the field you are currently trying to calculate with the average formula, you can use a formula like this:

divide(rollupConditionalSum($contacts_rtc_session_2,"avg_speaker_score_c","is_avg_populated_c",true),countConditional($contacts_rtc_session_2,"is_avg_populated_c",true))

I hope this helps!

Hi Jessica Taggart,

One way this can be handled with calculated fields:

Make a new checkbox in the module that has the avg_speaker_score_c field. Name the field "is_avg_populated_c". Put this calculation in that field:

greaterThan(strlen(toString($avg_speaker_score_c)),0)

Then, in the field you are currently trying to calculate with the average formula, you can use a formula like this:

divide(rollupConditionalSum($contacts_rtc_session_2,"avg_speaker_score_c","is_avg_populated_c",true),countConditional($contacts_rtc_session_2,"is_avg_populated_c",true))

I hope this helps!

Great solution, Patrick McQueen! With the availability of the rollupConditionalSum and countConditional formulas, should the enhancement I linked earlier should be closed as implemented?