Values & Percentages within same field


#1

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

Thanks,
Kevin


#2

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