Suppress If Duplicated 1

[sqw]

I have a report that runs and I have a column called hours. There are duplicated hours in this and I have selected suppress if duplicated. But the total for this column still includes the suppressed data. Is there any way to suppress if duplicated and for it to not be included in the totals if I do an insert summary.

Thanks

 

[PatriciaObreja]

Try to create a running total to summarize the hours.
Or a formula with whileprintingrecords before it.

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[sqw]

Thanks for the quick respone, I have tried the following formula
whileprintingrecords;
Sum ({Command.double05}, {Command.name(1)})
but this still comes up with the same total.
Do you have any more ideas please?
Thanks

 

[PatriciaObreja]

Create a running total that will summarize the field you need, and choose: Evaluate on change of the field and add the hours field. Place the running total where now you have the summary.

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[sqw]

I have tried that and it works great
Thanks alot