Insert percent sign in column styling for specific rows
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @CCrawford94
You can either use a formula tool to hardcode it tostring([field]+"%" or a table tool like the screenshot below.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, @danilang! I was playing with the column rules and having a bear of a time with them. Appreciate you dropping some knowledge!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you both for the solutions!