Summary Tab on Report - not exporting Sum data during export to excel | Community
Skip to main content
quarkmage
quarkmage
Level 3
May 1, 2026
Question

Summary Tab on Report - not exporting Sum data during export to excel

  • May 1, 2026
  • 2 replies
  • 30 views

I have a report that totals the number of label jobs in a day, and each job has a quantity.
The results are grouped by day, so the summary tab has the date, count of jobs for each day, and a total sum of labels produced (custom field - number format).
the data displays properly on the summary tab, and the complete data shows up on a PDF export, but the Sum column has no data in the excel data exports.  if i export tab delimited to notebook, the totals are also there.  any help?  thank you.


 

2 replies

quarkmage
quarkmageAuthor
Level 3
May 1, 2026

Not totally sure, but also experiencing similar issues where the summary tab is reporting on custom field, where excel export does not seem to display the data.

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
May 4, 2026

can you maybe convert your custom field column into text mode (in the view) and post it here, so we can see what format is exporting?

 

Occasionally the Support team has me change the valueformat, for example to “HTML” or “val” in order to get it to export. (obviously you can also submit a case to Support asking if there’s any way to get these exported values)

quarkmage
quarkmageAuthor
Level 3
May 4, 2026

Thank you ​@skyehansen for engaging.  Thought i would start with the experience league first.

 

Text Mode for the custom field, as accessed through the text mode in the report builder for this column.

aggregator.displayformat=customNumberAsStringaggregator.function=SUMaggregator.namekey=PS Quantityaggregator.valuefield=DE:PS Quantityaggregator.valueformat=customNumberAsDoubledisplayname=linkedname=directnamekey=PS Quantityquerysort=DE:PS Quantityvaluefield=PS Quantityvalueformat=customNumberAsString

Filter Rules for Report (not what you are asking for):
 

DE:PS Sent to QC=$$TODAY-1mDE:PS Sent to QC_Mod=betweenDE:PS Sent to QC_Range=$$TODAYprojectPortfolioID=63198ce50003632927868d003a73d014projectPortfolioID_Mod=in
skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
May 4, 2026

Does anything change when you change the “valueformat=customNumberAsDouble” line to something like valueformat=val or HTML? Just wondering. I’ll also take a look at it in my sandbox in case I can replicate it and start troubleshooting.

Terms & ConditionsAccessibility statement

Loading footer...