Row rules for decimal places?

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

Reporting

Accepted answers

Felipe_Ribeir0

Hi @Carluccio555

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

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

Cumulative.yxmd

All comments

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

Hi @Carluccio555

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

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

Cumulative.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703