KPI Not Working with Computed Field

I have a Help Desk site that has a library for Service Requests (site was created from the MS 40 templates).  I added a column for Resolution Time to calculate the time it took to resolve an issue and the formula for the column is =INT(([Resolution Date]-[Start Time])*24) and the data returned is set to Number. I then created a view that displays my closed service requests with Resolution Time as a column.  When I try to create a KPI using this list and a view that I created, the option on the KPI to 'Average' a column is grayed out.  The only option on the KPI I have is to Total the number of items or filter based on criteria.  The last radio button where the Sum and Average functions is located is grayed out.

Any ideas why?  I've used the Average functionality on other lists.  I'm wondering if it's because I have a computed field instead of a number.

Yes, it is because it is a calculated field.

Hi,

Does your calculated column appears in the AllItems view? I had a similar problem and that's how I've resolved it. Once the calculated column is part of the AllItems view, you can then work with any other view(s) that has the calculated column and KPI will show the column and all the options.

Regards,

DJ Lordee