Pivot App Zero Values
I'm using Pivot App to summarize the number of records from a variety of reports. It works great, but if there are no records in a report, the pivot table will report blank. I was hoping for a "0" value, as I'm pushing the data in these fields as number summary in the Dashboards/Portals.
Other than creating new columns with IF statements, or separate sheets with countif cross-sheet formulas, is there a solution I can apply to the Pivot App?