Insert percent sign in column styling for specific rows

[CCrawford94]

Is it possible to create a formula in the Table to add a percent sign to data. For example my data looks like below:

AVG Percent	20
AVG Amount	500
Highest Percent	40

I would like to make it look like this:

AVG Percent	20%
AVG Amount	500
Highest Percent	40%

Is this possible by creating a formula in the table row rules?

[Blake]

Hi @CCrawford94 

You can either use a formula tool to hardcode it tostring([field]+"%" or a table tool like the screenshot below. 

[CCrawford94]

I understand that this is how you would make the entire column have % but i want select rows to have % based on their counterpart row. For example the row with AVG Percent should have a % sign behind it and AVG amount should not. This is why im looking for a row rule for or column rule for styling in the table. is this possible?

[Blake]

Ahhh gotcha, my bad. I'd probably just toss a conditional formula on before the table tool. See the attached example. 

[danilang · Accepted solution]

Hi @CCrawford94 , @Blake 

Here's how you can do this in a column rule, directly in the table tool.  

Use Apply->Formula to target only the rows in question.

 

Dan

[Blake]

Thank you, @danilang! I was playing with the column rules and having a bear of a time with them. Appreciate you dropping some knowledge!

[CCrawford94]

Thank you both for the solutions!