How to decrease decimal places in a percentage?

Sam Lugiano

Hi,

How do I decrease the decimal places in the String Column to just read 230%🔺? My work is below.

Thank You

Terri Leong

You should use the ROUND function. You have two options:

1. Wrap your % formula with a =ROUND(([YTD FEES 2021]@row - [YTD FEES 2020]@row)/[YTD FEES 2020]@row, 0)
2. Wrap a ROUND around each of your calculations in the string =IF([%]@row <0, ROUND([%]@row*100,0) + "% up arrow", IF([%]@row <0, ROUND([%]@row*100,0) + "% down arrow".... etc...

Terri Leong

You should use the ROUND function. You have two options:

1. Wrap your % formula with a =ROUND(([YTD FEES 2021]@row - [YTD FEES 2020]@row)/[YTD FEES 2020]@row, 0)
2. Wrap a ROUND around each of your calculations in the string =IF([%]@row <0, ROUND([%]@row*100,0) + "% up arrow", IF([%]@row <0, ROUND([%]@row*100,0) + "% down arrow".... etc...

Sam Lugiano

Great. Thank you!