<variable> = <Form_Name>[criteria expression].sum(<Numeric Field Name>);   

First issue is if there is only one row then I get a null variable.
Second issue is when there is more than one row I am getting incorrect results.