| Re: Averaging Values in three columns [message #1044 is a reply to message #1043] |
Sun, 16 August 2020 21:15   |
ELFritzen
Messages: 47
Registered: November 2019
Location: North Carolina, US
|
Member |
|
|
I spoke too soon. The expression you provided did create the new calculated column with the averages I was interested in. However, when I I saved the new DW File, the the only thing that was saved was single column with the name of column being the numerator of the expression. The entire DW was overwritten with just this one column. I've attached the DW file to this post. I had replaced the variables in the expression you gave me with the actual column names I wanted to average in my DW File. After I calculated the new values into the new column, then saved the the DW file, the attached file is what I got.
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
Ed Fritzen
|
|
|
|
Search
Help
Members
Register
Login
Home
