More functions for calculated columns in SCIEX OS


SCIEX OS 1.5 has the feature of calculated columns with several useful functions, including mean, max, absolute value etc. In future versions, IF statements, SEARCH functions, and Trim functions would be extremely useful for setting up calculation columns with advanced calculations. Also, currently the custom calculation columns are all numerically based. There would be a huge advantage if the columns could be treated as text for searching for key strings within text, such as Charge State or Component Name. This would allow almost anything that is currently done in queries to be done in SCIEX OS tables. 


1 Comments Jan 25, 2019 3 Views Product: SCIEX OS Software

Posted: 2019-09-30

More useful functions would be round, vlookup and log10.