I am working with email data. There are columns with dollar amounts and percentages. I am attempting to average a column of percentages within a pivot table. Unfortunately, the cells in the pivot table are blank.
I can sum and count dollar amounts in the pivot table but when I try to average, sum, etc. the percentage column (open rate for emails), I get no result.
Am I missing something?
After working on this for half an hour I decided to post the question. After posting the question, I went back to the sheet are removed all formatting from the column (again), refreshed the pivot table and it works perfectly. It must have had something to do with formatting the column as a percentage in the original spreadsheet.
It sounds like, when your data was imported, the % symbols may have been read as text. When this is the case, LibreOffice won’t average them.
To fix this, I suggest a regex find-and-replace:
Find: (.*)%
Replace: $1
(Make sure to enable Regular Expressions in the search box.)
This will give you numbers, which you can average, or convert to %, as need be. (If you convert them to %'s, LibreOffice will recognize them as such.)