Time Calculation

Hi All,

I am working on a report which requires a calculated field, Technically these requirements will use the time value from dimensions. How will i be able to calculate time difference/combination if the values are from a dimension?

for example:

Order Time: 10:00 AM

Assigned order in to driver Time: 10:10 AM

Assigned order out to driver Time: 10:30 AM

I have to get the "at Door Time" by [(Assigned order in to driver Time)+(Assigned order out to driver Time)]/2

how will i able to compute the required value in JDM?


Thanks in advance.

1 comment

Please sign in to leave a comment.