Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: SUM Value from Linked Table Post Reply Post New Topic
<< Prev  Page  of 2
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 26 Oct 2013 at 4:31am
link table 3 to table 2 on both route id and locationid
create a formula to do a datediff on arrival and departure fields.
you have tio choose but you likely want to use minutes
//serviceminutes
datediff('n',table3.arrivaltime,table3.departuretime)
you can sum this formula field at the group level to get the total minutes for a route id (or use a running total if you want).
you can use that summarization (or RT) in another formula to get a persentage or a different if you want.
you can alos /60 to turn it into hours to more easily show it in comparison to total hours 
IP IP Logged
<< Prev  Page  of 2
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum