Function: avgif()
Usage
avgif(<condition>, <Numbers>) : Number
The avgif function is used to calculate the average among the numbers included as parameters that meet the given condtion.
Possible conditions (0 is just used as an example):
| <>0 | Not equal to zero |
| >=0 | Great or equal to zero |
| <=0 | Smaller or equal to zero |
| >0 | Greater than zero |
| <0 | Smaller than zero |
Examples
avgif(">0", 0, 10, 20) => 15
Learn more about how you can get started using the Formula Field.