Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Insert percent sign in column styling for specific rows

CCrawford94
7 - Meteor

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 Percent20
AVG Amount500
Highest Percent40

 

I would like to make it look like this:

 

AVG Percent20%
AVG Amount500
Highest Percent40%

 

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

6 REPLIES 6
Blake
12 - Quasar

Hi @CCrawford94 

 

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

 

Blake_0-1586795718674.png

 

CCrawford94
7 - Meteor

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
12 - Quasar

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

 

Blake_0-1586797704809.png

 

 

 

danilang
19 - Altair
19 - Altair

Hi @CCrawford94 , @Blake 

 

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

 

c.png

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

 

 r.png

 

Dan

 

 

 

Blake
12 - Quasar

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
7 - Meteor

Thank you both for the solutions!

Labels
Top Solution Authors