Currently each report run must have all of the quantities converted to numbers in order to sum. They are stored as text in the system and the excel report. In order to easily and quickly work with quantities - they should be numbers not text.