| Re: Averaging Values in three columns [message #1045 is a reply to message #1044] |
Mon, 17 August 2020 13:54   |
thomas
Messages: 663
Registered: June 2014
|
Senior Member |
|
|
I forgot, official DataWarrior 5.2.1 still contains a bug when writing formulas to a file, if these formulas contain newline-characters. Thus, the correct answer from my side should be this (without a newline at the end):
(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
[Updated on: Mon, 17 August 2020 13:54] Report message to a moderator |
|
|
|
Search
Help
Members
Register
Login
Home
