Convert number to percentage

[emiafshar]

Hey!

I was hoping to convert a column in my workflow to %.

Screenshot below - (column - "Difference" - this is the difference between the Merival and ZEUS columns)

Thanks :)

[Thableaus]

Hi @emiafshar

It depends of what kind of percentage you're talking about.

I assume you're calculating your percentage as = (Zeus - Merival)/Zeus * 100

So you can create a Field - Named as Percentage Difference, with the calculation above, and the use the following function:

ToString([Percentage Difference], 2) + '%'

The "2" rounds the number to 2 Decimal Places.

Cheers,