Ignoring null values in sum

[Alice Cambioli]

I have a variable of "totalamountraised" that i would like to find the mean for. Some observations have the value 0 so I would like to ignore them in the calculation, but without dropping them from the dataset. How can I do?

[Joro Kolev]

Can you provide a sample dataset using -dataex- and describe what you want with a reference to this dataset?

In particular do you want to do this by groups?

If you want an overall calculation the following should work:

summ totalamountraised if totalamountraised!=0

[Alice Cambioli]

Thank you that is what I was looking for!