Need help with service rating expression (formular)

jpeangeles · 2024-12-17T13:26:48.056Z

I am developing an App that rates services. Have data type service and field “service score” which is numbers. I have provided a dropdown of numbers 1 – 10 from which users select to score a service. I want the rating to display the average score e.g if only one user rates a service and the user selects 8, 8 will be displayed as rating in the repeating group “RG_Rating”. On the other hand, if 2 users rate the service and one of the users selects 8 and the other one selects 7, the rating will be: 8+7/2 = 7.5. I was thinking that an expression like this could work " RG_rating list of services each service score: sum / RG_rating list of services: count". But the system doesn’t provide me possibility to sum RG_rating list of services each service score as above. Any help with an expression that would work will be greatly appreciated.