Delay

[prabhas277]

Hi experts,

I am working one travel based project in this one KPI like "on time guest pick up" .HOw to calculate the that ont ime guest pickup?

[sunny_talwar]

What fields do you have in your database? This is a very open ended question and a open ended answer would be to calculate the difference between 'Time when they are actual picked' - 'Time when they should have been picked'

For a better response, you will have to provide more details.

HTH

Best,

Sunny

[avinashelite]

Hi Prabhas,

As sunindia‌ stated , you can calculate the time difference with the help of interval function if it yields 0 then its on time pick up other the other way.

try like this :

interval( A-B, 'D hh:mm' ) where A=97-08-06 09:00:00 and B=96-08-06 00:00:00 returns:

String	365 09:00
Number	365.375

where A and B would be your Pickup and excepted time of pickup