I have a SP list that I use as the data source for a PowerApp. For reporting, I have an Excel spreadsheet in OneDrive linked to that SP List. In that spreadsheet, I build Pivot tables and charts for reporting purposes. All of that works. Here is my problem for which I need help - this is blocking me from moving forward on a critical project:
-In the SP list, there is a duration calculation column based on two dates in other columns. That column properly sends over to the Excel spreadsheet as a General column. There are no blanks, but there are some zeroes. (I've tried making in numeric as well.)
-In one of my Pivot tables, I want to show the average duration for the records in a set of areas.
-That Pivot table results in the #DIV/0! error on all rows (a row for each of the set of areas, and a grand total)
I have looked and looked and set most every setting I can find, and nothing makes this work. I've tried deleting and recreating after refreshing multiple times.
I somehow suspect that this has something with the data being pulled NOT being what I think is being pulled. I've tried filtering out parts of the data set that could be blank. The zeroes in the duration column need to stay because the duration was indeed 0 days. Plus that would be in the numerator of the Average calculation, not the denominator, so that can't be it.
Can anyone help? Thank you so much!!!!
Bookmarks