Skip to main content
Participating Frequently
Dec 6, 2018 3:33 PM UTC
Question

How can include/exclude fields in calculation ?

Hello,

I got a question.

I have 8 fields which could be ted from 1 to 6 and if they could not be rated for certain circumstances it would get the value of x.

I wanat to calculate the avarage of rated parameters.

When I use the "average" function in calculation the number of enetered information would be fixed. That means if all parameters are rated the result is ok but if a parameter could not be rated it ruines my calculation (while the number of species are fixed in this case 8).

Isthere any solution for my problem? such if a value is not zero it counts otherwise should be negelcted.

Please help me.

BR

This topic is closed to new replies. Start a new post to keep the conversation going.

2 replies

try67
Community Expert
Community Expert
Dec 6, 2018 4:09 PM UTC

I've posted a function that does just that on the forums... Try searching for "average calculation".

Translate
Participating Frequently
Jul 11, 2019 10:23 AM UTC

Thank you very much .

Quite helpful.

BR

Translate