A summary field will summarize calculation fields. Any field of type number or for which the return type is specified as number can be summarized provided that it is defined in the same table.
Check the specified return type for your calculation to make sure that "number" is selected and make sure that this field and the summary field are defined in the same table.
Thank you again,
worked like a charm.