openmolecules.org Forum: Functionality » Averaging Values in three columns

Home » DataWarrior » Functionality » Averaging Values in three columns

Show: Today's Messages :: Polls :: Message Navigator

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

Report message to a moderator

[Message index]

		Averaging Values in three columns By: ELFritzen on Fri, 14 August 2020 23:19
		Re: Averaging Values in three columns By: thomas on Sat, 15 August 2020 13:40
		Re: Averaging Values in three columns By: ELFritzen on Sun, 16 August 2020 19:19
		Re: Averaging Values in three columns By: ELFritzen on Sun, 16 August 2020 21:15
		Re: Averaging Values in three columns By: thomas on Mon, 17 August 2020 13:54
		Re: Averaging Values in three columns By: ELFritzen on Mon, 17 August 2020 15:57

Previous Topic:	Tagging Data to a Particular Assay
Next Topic:	Smiles to Structure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Apr 07 00:11:00 CEST 2025

Total time taken to generate the page: 0.06103 seconds