Creating a report for sum of a string field

[samadam]

I am trying to develop a report to calculate the sum of a field which is created as a string field. When I tried to create a report it doesn't give me an option to select this field. IS there any other way to accomplish this?

[Mohith Devatte]

Hello ,

Are you are trying to do this in PA?

IF yes and if the string field is storing only numbers then change the field type to integer or if it is storing decimal numbers  change the type to floating point number and then try to add it.

Please accept this solution if you find it helpful

thanks

[samadam]

No, its a regular report i am developing

[Mohith Devatte]

Is it a report that you are building through script ?if so can you share the snippet so that i can suggest

[samadam]

Unfortunately not, I am trying to sue the report builder. Is there a way to script this?