Hello everyone !!

 I try to use CR in VS 2008 (VB .net) and I've got a problem while using SUM in formula Fields.

 I would like to make the SUM of one field (montant) in a table (courses) but all it says when I save is "there is an error in this formula". How can I do to get the SUM of my field please ??

 Thanks

 Ps : I've try in the formula workshop :

code1

Sum ({COURSES.MONTANT})

code 2

Sum ({COURSES.MONTANT});

I'm using Oracle database and my fields "montant" is define as String because in Oracle Express there are not single type. So I've to use a String type to save my data.

Table COURSES :

Column NameData TypeNullableDefaultPrimary Key DATE_COURSESDATENo - - NOM_ALIMENTSVARCHAR2(4000)No - - PRIX_ALIMENTSVARCHAR2(4000)Yes - - QTEVARCHAR2(4000)Yes - - MONTANTVARCHAR2(4000)Yes - -

1 - 5

< ="" ="text/">

< name="p_arg_names" value="11141129549203626" =""> < name="p_t01" value="15347" id="OB__NAME" ="">

< name="p_arg_names" value="11143605700225196" =""> < name="p_t02" value="1201344102359" id="P0_PPRTIMESTAMP" ="">

Thanks  It work great