% Sign for numbers

[wenyg]

Hi, is there a simplified way to make decimal places (it has to be a number as it is calculated in the formula tool) into percentage signs and narrow down to 2 decimal places (can this be double too? if not, string is fine too) . I have created the following but thought this is too complex as i need to apply this on multiple parts of the workflow.

I tried fixed decimlas 19.2 but not really narrowed down to 2 decimal places.

[ed_hayter · Accepted solution]

Are you asking for this? Mutiplied by 100 then rounded to 2 d.p. with the 0.01 parameter after round. Forced it to string so i could concatenate the % sign afterwards

[wenyg]

Hi

Sorry coming back to this. How can i make the percentage sign into a number after forced it to string? I use select tool to make it a double but the percentage sign disappears.