I am currently creating a dashboard for our executive team. I have created a new inquiry for the fields I need to pull in. I am using the KPI widget and the labor looks like it is coming through in seconds and the inquiry is doing the same when I use SUM in the total aggregate function. Does anyone know how to make it add minutes/hours?
Best answer by kyle90
@jsteck - Found this post while trying to do something similar - hopefully you’ve figured this out in the meantime, but just in case any one else gets stuck here.
You’ll want to convert the LaborTime to decimal, this will give you the total labor hours in minutes which you can then divide by 60 to get total labor hours. This should aggregate as a SUM in the GI
=CDec([AMMTran.LaborTime])/60
+4
Might be helpful to post some pictures or a .zip of your current GI so we can see it. I’m a visual kind of guy and it really helps me to see it
@jsteck - Found this post while trying to do something similar - hopefully you’ve figured this out in the meantime, but just in case any one else gets stuck here.
You’ll want to convert the LaborTime to decimal, this will give you the total labor hours in minutes which you can then divide by 60 to get total labor hours. This should aggregate as a SUM in the GI
=CDec([AMMTran.LaborTime])/60
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
