Hi All, so I have a pivot table that is based on a query to a database, that I need to calculate what is called Hours Per RO.
This is calculated by taking Invoice Hours divided by total number of work orders. InvoiceHours / #ofWorkOrders.
I have the sum of invoice hours working, but I need to divide it by the count of work orders. How do I create a calculated field to do this?
I tried to do =invoiceHours/ COUNT(#ofWorkOrders) but it gives me a count of 1 for the # of work orders/
Thank you
Bookmarks