Values & Percentages within same field

I currently have a table the has a list of service lines and a column for metric value. My issue is some service lines require % and some service lines require values. How do I format my table/visual to display the correct format?

Example Data

Service Line Value
Service 1 1,250
Service 2 .75
Service 3 385
Service 4 .05


Check out this forum thread

This is really the only way to complete something like this right now.

See if you can apply the technique to your report