If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Could you please help me on the below scenario.
I need to calculate Average Weight of the Site.
Need output. I used the below formula and getting the right answer but the site YYYY having (-) value. I need to display avg score on both of the site value.=aggr(Sum(Score)/count(Score),ID)
@Prabhu1204 May be this?
Sum(TOTAL <ID> Score)/Count(TOTAL <ID> Score)
View solution in original post