Supressing "Detail Feilds" within a "Group Header"

[gusc999]

I have a report that is grouped into PO's I need to take the time from the first transaction and from the last transaction from that PO and get a time difference. Any Help would be greatly appreicated.

-Gus
HAPPY NEW YEAR!!!

 

[lbass]

Create a formula like this:

datediff("s",minimum({table.datetime},{table.groupfield}), maximum({table.datetime},{table.groupfield}))

This will give you the results in seconds.

-LB

 

[gusc999]

LB,

Appreciate you helping me with this, below are the issues I'm having with your suggestion. Please advice...

When I do the following:
datediff("s",minimum({@Date Time},{POHHDR.PHHVNA}), maximum({@Date Time},{POHHDR.PHHVNA}))
I get this ERROR "THE FORMULA RESULT MUST BE A BOOLEAN"

When I do the following:
datediff("s",minimum({@Date Time},GroupName ({POHHDR.PHHVNA})), maximum({@Date Time},GroupName ({POHHDR.PHHVNA})))
I get this ERROR "THIS FIELD CANNOT BE USED AS A GROUP CONDITION FIELD"

Thank you,

 

[gusc999]

LB,

The report was corrupt I redesigned it and it worked fine...

Thank you!!