-
amerkikicAsked on August 9, 2019 at 2:25 PM
Hello,
For the debit memo file, when I download the Excel report for all submissions in the Inbox, the sum function does not correctly add up the values in the unfiltered column titled original chargeback value. Highlighting all the values does not correctly sum either. Is there a way to fix this?
Thanks!
-
David JotForm Support ManagerReplied on August 9, 2019 at 3:06 PM
That is happening because some of the values contain the dollar sign ($), so they are read as text, nor as numbers. You would need to format/convert the whole column to numbers.
I believe that this guide would help: https://support.office.com/en-us/article/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885
Let us know if you have more questions.