openmolecules.org Forum - RDF feed
https://openmolecules.org/forum/index.php
cumlativeSumInCategory
https://openmolecules.org/forum/index.phpindex.php?t=rview&goto=1294&th=486#msg_1294
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
]]>chemtv2021-05-19T13:56:13-00:00Re: cumlativeSumInCategory
https://openmolecules.org/forum/index.phpindex.php?t=rview&goto=1296&th=486#msg_1296
the computation fails because the instruction contains an error in the syntax. In your example, plateID and penalties are not variables, but label-like column headers. For this reason both are to be enclosed in quotes. To enable a computation, the formula thus shall be written as
cumulativeSumInCategory("plateID", "penalties")
Note, `cumulativeSumInCategory` adds line by line the penalties for the plateIDs, and accounts for all lines already scrutinized. This pattern is used in column «freq3» in the example attached below.
Your description of the anticipated results differs from this, though. It is better described by the formula