the calculation sum() function allows you to summarize data from another table, and also add additional parameters to the calculation, EG:
If ( table::year = Year(Get(CurrentDate)) ; Sum(relatedTable::amount) ; "" ), say for instance you only wanted to show the sum amount for records of the current year.
The Summary Field Type will only return the sum from the found set, or sub-summarized set. Differences are (and should be) expected.
You haven't said what you're trying to do, just that they are different, so we can't recommend which to use.
Thanks Mike .
I was trying to get a SUM in a found set . I think from what you're saying the summary field is fine and that is also what seems to be giving the correct result in a found set.
As for the calc function ... I think I can use it in other situations...
Dr. Binu Alexander
Bridge Connectivity Solutions , New Delhi
Correct, if that's your goal then the summary field type is what you want.
When you drop that field into summary layout parts, like leading/trailing grand summary or subsummary, it will automatically summarize to that divided group or found set as needed.