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

Thanks,
Kevin

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

Hi @sam.mckay , just wanted to check if you’ve seen any improvements in this area?

It is a common request to have a Gross Profit % built into my clients’ reports or a Contribution Margin below the associated $$. Using the FORMAT option for this one row compromises performance hugely. I keep thinking I can’t be the only person preparing ‘traditional’ finance reports and facing this issue!

I can put it in a separate table but the order of rows often makes that a shocking alternative.

Thanks in advance.