summing distinct fields

[denthui]

Some fields in my report are duplicate, so when I try to calculate the grand total, it sum all fields. Is there a way I can sum just distinct value.

 

[statsman]

We shall use an example where you have 6 fields.
FieldA
FieldB (duplicate of FieldA)
FieldC
FieldD (duplicate of FieldC)
FieldE
FieldF (duplicate of FieldE)

In your GrandTotal text box enter

=Sum([FieldA]+[FieldC]+[FieldE])

 

[denthui]

thanks for your reply