Hi,
I have submit several tickets since almost 2 weeks, we did not had any reply back??
I hope someone an help me here, here are my questions :
1- I'm trying to create a simple form for my employees to fill the working hours.
- Is there another way to have Date and Time separately? We found really hard to fill the time into the Date/Time field.
- Also we need a field that will deduct the lunch break, Here is the formula used into the total field :
(((((((Finnish - Start) / (1000 * 3600))).toLong())) + " Heures ") + (((((((Finnish - Start) / (1000 * 3600))).toDecimal() - (((Finnish - Start) / (1000 * 3600))).toLong()) * 60)).toLong())) + " Minutes"
We would need to deduct this field to the total : Lunch_in_minutes
2- In a report, how can I show the average of a column. I saw that we can enable that in the columns properties but it only shows on the table chart. We would like to be able to see a pie chart that represent the average in %.
I understand that it seems to be into "Add Aggregate Formula" but I'm always getting some errors.
Can you help me on that?