openmolecules.org Forum - RDF feed
https://openmolecules.org/forum/index.php
Averaging Values in three columns
https://openmolecules.org/forum/index.phpindex.php?t=rview&goto=1040&th=408#msg_1040
Thanks,
Ed
]]>ELFritzen2020-08-14T21:19:03-00:00Re: Averaging Values in three columns
https://openmolecules.org/forum/index.phpindex.php?t=rview&goto=1042&th=408#msg_1042
(if(isempty(A),0,A)+if(isempty(B),0,B)+if(isempty(C),0,C))/
(if(isempty(A),0,1)+if(isempty(B),0,1)+if(isempty(C),0,1))]]>thomas2020-08-15T11:40:56-00:00Re: Averaging Values in three columns
https://openmolecules.org/forum/index.phpindex.php?t=rview&goto=1043&th=408#msg_1043
That worked perfectly.
Ed]]>ELFritzen2020-08-16T17:19:42-00:00Re: Averaging Values in three columns
https://openmolecules.org/forum/index.phpindex.php?t=rview&goto=1044&th=408#msg_1044
Thank you for your help. I'm a Synthetic/Medicinal Chemist who doesn't know a lot about databases, and I'm responsible for maintaining our corporate compound database.
Ed Fritzen]]>ELFritzen2020-08-16T19:15:36-00:00Re: Averaging Values in three columns
https://openmolecules.org/forum/index.phpindex.php?t=rview&goto=1045&th=408#msg_1045
(if(isempty(A),0,A)+if(isempty(B),0,B)+if(isempty(C),0,C))/( if(isempty(A),0,1)+if(isempty(B),0,1)+if(isempty(C),0,1))
I have attached the fixed file (removed two newlines). The downloadable DataWarrior development patch has fixed this issue.
Sorry for that, Thomas
]]>thomas2020-08-17T11:54:37-00:00Re: Averaging Values in three columns
https://openmolecules.org/forum/index.phpindex.php?t=rview&goto=1047&th=408#msg_1047
Ed]]>ELFritzen2020-08-17T13:57:52-00:00