Supress if duplicate function / sum

[johnism]

I have a report that I need a sum on , the only problem is that I need to use the (supress if duplicate option), so the record only apears once ( do to the grouping and a right outer join I get the qty displaing 3 time( links are correct for this return to get the decription I need))). But when I try to inlcuded a sum it sums all the fields inlcuding the supressed ones. Is there a way to sum only the visual feilds?

 

[synapsevampire]

Try using a Running Total, and in the Evaluate->Use a Formula place:

next({MyTable.MyDupingfield}) <> {MyTable.MyDupingfield}

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[johnism]

Thanks ,that worked