Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In a dynamic cross table, I would like to calculate an average a on a field which contains a time (HH:MM).
The type of this field is TIME.
Could you help me / show me how to make this calcule ?
Exemple 1 :
--> 10h00 am
--> 10h15 am
--> 10h30 am
The average calcul should give me 10h15.
Exemple 2 :
--> 10h45 am
--> 11h00 am
--> 11h15 am
The average calcul should give me 11h00.
Thanks in advance if you can help me.
Regards,
Jérémie
The answer is :
avg(nam_of_field)
and click HOUR in tab number.