Totals as number in Export?
I have a broadcast that sends out a file daily. I have added totals for each date column at the bottom using the "Sum column" feature when you click the dropdown.
The issue I have is that while I've managed to get the actual report to display numeric values, the totals come up as Text in the exported file. The way I managed to get the numeric values to be displayed in the report is to get rid of the thousand separator, because this converts the values to text upon exporting.
Is there a way to get around this and format the totals as numeric values?