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 Percent20AVG Amount500Highest Percent40 I would like to make it look like this: AVG Percent20%AVG Amount500Highest Percent40% Is this possible by creating a formula in the table row rules?

Insert percent sign in column styling for specific rows

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?

Reporting

Output

Accepted answers

danilang

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

PercentinTable.yxmd

All comments

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703