openmolecules.org Forum: Functionality » tip on add calculated values

Home » DataWarrior » Functionality » tip on add calculated values

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

tip on add calculated values [message #84]

Fri, 31 July 2015 19:23

mvamos
Messages: 24
Registered: January 2015
Location: US

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?

Report message to a moderator

Re: tip on add calculated values [message #85 is a reply to message #84]

Mon, 03 August 2015 19:43

thomas
Messages: 722
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

Report message to a moderator

Re: tip on add calculated values [message #88 is a reply to message #85]

Mon, 10 August 2015 19:50

mvamos
Messages: 24
Registered: January 2015
Location: US

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 944 times)

Report message to a moderator

Re: tip on add calculated values [message #91 is a reply to message #88]

Wed, 12 August 2015 02:35

mvamos
Messages: 24
Registered: January 2015
Location: US

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.

Report message to a moderator

Re: tip on add calculated values [message #94 is a reply to message #91]

Fri, 14 August 2015 07:35

thomas
Messages: 722
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

Report message to a moderator

Previous Topic:	Calculate LE & Tox - IC50 column not chooseable
Next Topic:	UI suggestions for Table and Form views

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Feb 05 17:51:27 CET 2025

Total time taken to generate the page: 0.03242 seconds