I want to perform a script activity on an Account Send Summary report I dropped into a Data Extension. The current numbers inside of the system cannot be logically filtered because they contain "," and "%". Is there a way to remove them and convert the string into numbers using ssjs in a script activity for automation?
I would prefer using ampscript but I can't use it inside of the script activity. If you know another way of me converting the numbers and filtering only the rows meeting my requirements, that would be helpful.
My requirements is to show results in an email where the campaign had less than 95% deliverable rate.