I have a table tool output as follows:
(If it helps I have a screenshot with and without column headings)
WIth column headings you can see there are 4 tables, I have just removed the column headings and added my own:
As you can see I have managed to set a row rule to Italicize the Gross Margin % line. But the numbers don't look like %. They are the decimal rounded up or down to 0 or 1.
What is the best approach to get percentage format, to 1 decimal place with % symbol eg. the data is 0.432 but the output required is 43.2%
Thanks
Solved! Go to Solution.
Hey @Carluccio555,
In a table tool you do have the option to specify how many decimals you want to show.
You can also add a suffix there, so for you a "%".
But of course then you would need to multiply your values before the input into the table tool by 100.
Those are the per column rules meaning the decimal places would apply to the whole column not just the %
You could use the above formula just for the % table, before unioning it with the other tables:
Tostring(100*[_CurrentField_], 2) + '%'