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?
Jessica Taggart, the functionality you are seeking is not available natively in Sugar and is tracked under enhancement request # 68025 (you will need to be a support-authorized contact to view this link). I recommend filing a support case with Sugar referencing this enhancement so they can continue to weighing the importance of implementing this feature.
As André Lopes mentions, you could achieve this by defining a custom calculated formula. Another option would be to handle this via a logic hook. Both of those solutions require development expertise. If you do not have access to a current development team, my company, Upsert, can deliver the solution you are seeking.
Jessica Taggart, the functionality you are seeking is not available natively in Sugar and is tracked under enhancement request # 68025 (you will need to be a support-authorized contact to view this link). I recommend filing a support case with Sugar referencing this enhancement so they can continue to weighing the importance of implementing this feature.
As André Lopes mentions, you could achieve this by defining a custom calculated formula. Another option would be to handle this via a logic hook. Both of those solutions require development expertise. If you do not have access to a current development team, my company, Upsert, can deliver the solution you are seeking.
