Is there a formula to show as %
What I am trying to do is have my overview brought in automatically each month so it doesn't have to manually be typed in. The struggle I'm having is it wants to bring in as a decimal instead of a %.
Below is the formula I am currently using. Is there a way to make it show as %
="We are at " + [% closed rate]@row + " closed rate on ticket status for the month of "+[Month]@row.
The result is We are at 0.9605 closed rate on ticket status for the month of July
What I need the result to be is "We are at 96.05% closed rate on ticket status for the month of July"
Note: My % closed rate column is formatted to %.
Help Article Resources
Check out the Formula Handbook template!