Row rules for decimal places?

[Carluccio555]

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

[FrederikE]

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. 

[Carluccio555]

Those are the per column rules meaning the decimal places would apply to the whole column not just the %

[Felipe_Ribeir0 · Accepted solution]

Hi @Carluccio555 

You could use the above formula just for the % table, before unioning it with the other tables:

Tostring(100*[_CurrentField_], 2) + '%'