I have a table, set up like the chart below and I need to add a % to only the bottom two rows of the table, I thought there would be a way to write a formula in the row rules however I cannot seem to figure it out. So, to restate, I only want to add the % to the % of Aged Breaks total rows at the bottom but no other rows and only the numeric columns. Description1-34-67-910+TotalDay Over DayUser 1 Current Day302050 Previous Day302050User 2Current Day3019121 Previous Day3017110User 3Current Day000000 Previous Day000000TotalCurrent Day6039180 Previous Day6037162% of Aged BreaksCurrent Day540540100 Previous Day3701747100

Adding percentage sign to rows in Table tool

I have a table, set up like the chart below and I need to add a % to only the bottom two rows of the table, I thought there would be a way to write a formula in the row rules however I cannot seem to figure it out. So, to restate, I only want to add the % to the % of Aged Breaks total rows at the bottom but no other rows and only the numeric columns.

	Description	1-3	4-6	7-9	10+	Total	Day Over Day
User 1	Current Day	3	0	2	0	5	0
	Previous Day	3	0	2	0	5	0
User 2	Current Day	3	0	1	9	12	1
	Previous Day	3	0	1	7	11	0
User 3	Current Day	0	0	0	0	0	0
	Previous Day	0	0	0	0	0	0
Total	Current Day	6	0	3	9	18	0
	Previous Day	6	0	3	7	16	2
% of Aged Breaks	Current Day	54	0	5	40	100
	Previous Day	37	0	17	47	100

Reporting

Tips and Tricks

Help

Accepted answers

CoG

Here is an example for you that should do what you're looking for:

Sample Workflow.yxmd

All comments

CoG

I could be wrong, but I do not believe that you can edit the data like that in the Table Tool. What format is your data in before going through the Table Tool, because that would be quite simple too achieve with a Multi-Row tool and Multi-Field tool before being sent to the Table Tool.

MattR79

It's coming out of a formula tool just prior to the table tool, if there is another way to handle it other than in a table, then I welcome that option as well. I am not locked into doing it any particular way.

CoG

Here is an example for you that should do what you're looking for:

Sample Workflow.yxmd

MattR79

That did exactly what I needed it to do, thank you.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703