I created 2 fields on that is a summary field with a total ( FIELDNAME ) and another Calculated field and used the SUM aggregate function ..
Can someone explain which to use and when ... and in what ways are they different ?
I tried reading the FM help section but not sure when to use which technique ..
In my solution they are giving different values especially when working with a found set .... So I guess SUM and TOTAL are not the same !