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

]]>

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")

Your description of the anticipated results differs from this, though. It is better described by the formula

categorySum("plateID", "penalties")

Norwid]]>

regards,

Greg]]>