| Averaging Values in three columns [message #1040] |
Fri, 14 August 2020 23:19  |
ELFritzen
Messages: 47
Registered: November 2019
Location: North Carolina, US
|
Member |
|
|
I'd like to average the values contained in three different columns into a new calculated column. The expression I use is (Column1+Column2+Column3)/3 to set up the calculated column. The calculated column only returns values when there is a value in each of the columns. Is there a way to write the expression that will return an average when one of the values was not determined?
Thanks,
Ed
Ed Fritzen
|
|
|
|
Search
Help
Members
Register
Login
Home
