openmolecules.org

 
Home » DataWarrior » Functionality » tip on add calculated values
tip on add calculated values [message #84] Fri, 31 July 2015 19:23 Go to next message
mvamos is currently offline  mvamos
Messages: 12
Registered: January 2015
Junior Member
Hello. I'm having trouble doing a simple calculation withing DW. I want to multiply my IC50s by 1000 to convert from micro to nanomolar. When I input "NormalizedULK1IC50s*1000" where the first part was input using the "Add Variable" button within the normal dialog box, it output the same "NaN" value for every cell, rather than the numerical value.

Perhaps my syntax was off?
Re: tip on add calculated values [message #85 is a reply to message #84] Mon, 03 August 2015 19:43 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 155
Registered: June 2014
Senior Member
Hi, your syntax is perfect. I just tried on my Linux installation, with a column named "Normalized ULK1 IC50s" and with
your exact syntax, which worked well. Which platform do you use (Mac, Linux, Win32 or Win64 and which JRE)? I will then
retry under similar conditions. Thomas
Re: tip on add calculated values [message #88 is a reply to message #85] Mon, 10 August 2015 19:50 Go to previous messageGo to next message
mvamos is currently offline  mvamos
Messages: 12
Registered: January 2015
Junior Member
Hi Thomas. I use Windows 7, 64 bit. I have the most recent version of the DW software (64 bit) and also have 64 bit Java installed. I included a screen shot of the column and formula.
  • Attachment: Untitled.png
    (Size: 21.33KB, Downloaded 361 times)
Re: tip on add calculated values [message #91 is a reply to message #88] Wed, 12 August 2015 02:35 Go to previous messageGo to next message
mvamos is currently offline  mvamos
Messages: 12
Registered: January 2015
Junior Member
Since having this issue, I've been able to perform a -log(variable) calculation on another column successfully. Not sure what the issue was previously. I got around the issue by doing the calculation within Excel first, then merging the data.
Re: tip on add calculated values [message #94 is a reply to message #91] Fri, 14 August 2015 07:35 Go to previous message
thomas is currently offline  thomas
Messages: 155
Registered: June 2014
Senior Member
I could not reproduce the issue. If you have it again, could you please send me a small file. I assume that there were some strange characters in the original cells. Thanks in advance, Thomas
Previous Topic: Calculate LE & Tox - IC50 column not chooseable
Next Topic: UI suggestions for Table and Form views
Goto Forum:
  


Current Time: Wed Oct 24 06:41:55 CEST 2018

Total time taken to generate the page: 0.00550 seconds