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

I've created a calculated field where I've successfully created a rollupAve function to a related module:

rollupAve($contacts_rtc_session_2,"avg_speaker_score_c")

This works great, but I'd like for it NOT to include in the calculation any instances where the field "avg_speaker_score_c" is empty. Is this possible? If so what do I need to change the formula to?

Parents

0 André Lopes over 6 years ago

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

André Lopes
Lampada Global

Skype: andre.lampada
0 Jessica Taggart over 6 years ago in reply to André Lopes

is that like an IfElse statement? and would it go before the rollupAve or in between?

Reply

0 Jessica Taggart over 6 years ago in reply to André Lopes

is that like an IfElse statement? and would it go before the rollupAve or in between?

Children

0 André Lopes over 6 years ago in reply to Jessica Taggart

Not really. In fact you have to copy theh file include/Expressions/Expression/Numeric/AverageRelatedExpression.php into custom/include/Expressions/Expression/Numeric/CustomAverageRelatedExpression.php
And modify the method getJSEvaluate accordingly.
Mind you have to update the method getOperationName and comments right before class definition accordingly.
Regards

André Lopes
Lampada Global

Skype: andre.lampada