Help Formatting a Percent formula 1

[harley1d]

Can someone please help me with formatting this formula? The formula is working but I can't not format it to only return one decimal space. Currently it is retuning 12.54%. How do I get this to return 12.5%?

I tried to convert the formula to a number to allow me to customize the number but it didn't work.

The formula is listed below:

Sum ({@Transfer})/DistinctCount ({HSP_ACCOUNT.HSP_ACCOUNT_ID})*100 & "%"

 

[lbass]

Use:

Sum ({@Transfer}) % DistinctCount ({HSP_ACCOUNT.HSP_ACCOUNT_ID})

Then click on the % icon in the toolbar to add the symbol. You can also use the toolbar to format to the number of decimals you want.

-LB