Mean

[#1]

Hello!

I will try to calculate an average, and I do not really know how I do, I now have a formula: Sum (Weight) / Sum (Total <ÅR_Kvartal> Weight). This formula can I use if I have to figure out the distribution or total number for each answer.

But how do I calculate average values ​​of the respective responses?

[jvitantonio]

aggr(Avg(Weight), Responses )    

Responses = name of field for responses

This will show you the average weight by reponse

[#3]

Hello again!

But I want to calculate the mean number of nights, do I then set it there instead?

[jvitantonio]

well, I  put "weight" because it doesn't say anytihng about nights You can replace the formula according to your needs

[#5]

I'm really not good at this......

A small clarification

I want to calculate the mean number of overnight accommodation, housing and quarters.

Sum (Weight) / Sum (Total <Year_quarters> weight) and I have been given the distribution of this formula

[#6 · Accepted solution]

But how do I write this expression?

[jvitantonio]

sorry, you'll need to post your app. because I don't get what ur saying