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 |
Solved! Go to Solution.
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.
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.
That did exactly what I needed it to do, thank you.