Forum Discussion
Solved
Pivot Table Summarize Values by Average Greyed Out
I am constructing a Recruitment Dashboard. One of the values I'm trying to include is the average for time to fill. Which is the time from the open date of a job to the close date of a job. When tran...
The solution is to change the formula in column E into something that always results in a number.
Could be:
=MAX(0,J2-E2)
Detlef_Lewin what’s the solution then? I need it to say time to fill to identify what’s being calculated.
The solution is to change the formula in column E into something that always results in a number.
Could be:
=MAX(0,J2-E2)
- That worked! Appreciate the help.