1 of 1 people found this helpful
This should work, returns Time in seconds:
ExecuteSQL ( "SELECT SUM(NUMVAL(TotalTime)) FROM Events"; "" ; "")
Try including the "As Agg" bit:
ExecuteSQL ( "SELECT sum NUMVAL(TotalTime) As Agg FROM Events"; "" ; "")
The alias (AS xyz) is not required here.
Sent from miPhone
Thanks. That works now. I forgot a set of parenthesis in the formula. Thanks again.