Add the results of aggregation formulas
Hi there,
I have a table that essentially contains timesheet data.
- Date
- Available hours
- Billable hours
- Sick hours
- Annual Leave Hours
etc
The current version of my formula calculating effective utilisation is
sum("available hours")/(sum("billable hours"-sum("sick hours")-sum("annual leave hours"))
But I'm getting a null result.
I'm wondering if there is a way I can sum the results of aggregations.
Thanks.