cumlativeSumInCategory [message #1294] |
Wed, 19 May 2021 15:56 ![Go to next message Go to previous message](/forum/theme/myThemeWithHFCSS/images/down.png) |
chemtv
Messages: 26 Registered: February 2015 Location: Indianapolis
|
Junior Member |
|
|
I am trying to use a calculated column to sum the values per a text category but I keep getting "NaN" as the result. Can you tell what the problem is?
Attached is an example table...
The formula that gives NAN is:
cumulativeSumInCategory(plateID,"penalties")
I am expecting a new column that has the sum 14 for the first 3 entries and 7 for the second 3 entries, (same number for each of 3 rows).
BTW, I have no success with frequencyInCategory either. Can the frequency count unique text strings (eg. SMILES) as well as numbers?
Thanks,
Greg
-
Attachment: Example.dwar
(Size: 1.19KB, Downloaded 325 times)
[Updated on: Wed, 19 May 2021 15:58] Report message to a moderator
|
|
|