I need to be able to group and sort on a data field that I converted from string to number format. However, once I change this field to numeric using tonumber({PREMPGARN.VENDOR}), I get an error message that reads "The String is non-numeric", and the report appears blank.

 

 

So, this field needs to be converted to a number, and the report needs to be grouped on this data field so I can export it To Excel in the desired format.

 

Any suggestions around this issue?