Powerpivot - 'Values' - average function

[LittleL]

Hello, could anyone help me with the below problem;

I have a table which includes the 'length of stay' (how many days someone has received the service). I want to pull this data month by month into a powerpivot chart and show the average.

For some reason it wont work it out, it 'counts' the data but wont work out the 'average', brings up a error message; 'error - calculation aborted: calculation error in measure '...': the function takes an argument that evaluates to numbers or dates and cannot work with values of type string'.

Does anyone know what this means and how I can resolve the issue?

Thank you in advance

 

[miguel.escobar]

I'm not getting the issue yet. Do you think that you could upload a copy of your workbook so I can take a look at it and see what you mean?

 

[Ian Bertie]

I'm not getting the issue yet. Do you think that you could upload a copy of your workbook so I can take a look at it and see what you mean?

Good morning All,

I am also getting the same error message.

When I use count it is OK

However when I use average I get the following error message

Regards
Ian

 

[RoryA]

What data type is that field in your table? Text?

 

[Ian Bertie]

What data type is that field in your table? Text?

The data type is a number

Regards
Ian

 

[RoryA]

Can you just confirm how you verified that - you did look at the actual field properties?

 

[Ian Bertie]

Good morning Rory,

I highlighted the relevant cell containing the data and checked the format cell category.

Ian

 

[RoryA]

You need to look at the field properties in the PowerPivot table. I suspect it's Text which would explain why Count works but Average won't.

 

[Ian Bertie]

Good morning Rory,

Sorted, thank you very much for your help

Ian

 

[RoryA]

Glad to help.