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?
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.