| Re: Category Filter logic [message #1124 is a reply to message #1123] |
Wed, 18 November 2020 21:55   |
nbehrnd
Messages: 211
Registered: June 2019
|
Senior Member |
|
|
Hello Greg,
once the properties are stored in DW's main table, both Boolean .or. and .and. may be used for further analysis. In the example below, I extended the initial query for molecular weights greater than 110 (yielding mesitylene) to one that would accept molecules with a molecular weight of either less than 80 .or. greater than 110 by the instruction
if((TotalMolweight<80) || (TotalMolweight>110), "True", "False")
in an additional column (Data -> Add Calculated Values). As expected, the second query yields both benzene and mesitylene now.
It is possible to use multiple properties of different columns, too. DW's mathematics, including logic expressions, which may be used are presented on
http://www.openmolecules.org/help/jep.html
Norwid
[Updated on: Wed, 18 November 2020 21:58] Report message to a moderator |
|
|
|
Search
Help
Members
Register
Login
Home
