ToString - adding percent sign to number

I have a column of percentages that I would like to format as a percentage (ex: 75.3545%) rather than .753545

Currently, I have a formula tool inserted and am using

ToString(Round(([column]*100),0.4))+"%"

I am getting an error message saying "Parse Error at char(0): Formula: tried to apply numeric operator to string value".

Currently, the column is being stored as "string" however I have also tried double, fixed decimal, int64, and v_string.

Is this the correct formula, and what type should the data be stored as? Does this hold true for converting data into dollars ($)?

Error Message

Accepted answers

philipmannering

That looks right. Just make sure [number] is a Float, Double or Fixed Decimal. And I think 0.4 should be 0.0001.

If you still continue to have issues, please share a sample of the data, and some helpful folk will share a workflow back with you.

Philip

All comments

philipmannering

That looks right. Just make sure [number] is a Float, Double or Fixed Decimal. And I think 0.4 should be 0.0001.

If you still continue to have issues, please share a sample of the data, and some helpful folk will share a workflow back with you.

Philip

sswift13

Thanks Philip! This worked to format both the percentage and dollar columns, however, the percent sign isn't showing up in the output, whereas the dollar sign is. This is the formula I'm using. The data is being stored as a fixed decimal of 100.4

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703