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!

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

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

Hi Chris Raffle,

Thanks for this feedback. I have gone ahead and closed the ER with an additional note in the description indicating the functions discussed here.

Thanks so much - worked a treat! I was trying something similar but didn't realise I needed the extra checkbox field. Thanks! 

This is really amazing. Great information about blog.

This is really amazing. Great information about blog.