Hi @joanq , Assuming that the field you want to convert to a percentage is called [Field1] and it's of a double/float/fixed decimal data type then your formula should be the following: Tostring …

Mar 20, 2018 · Hello everyone! I was hoping y'all could help me out with a small problem. The data set I have has numbers as decimals (i.e. 0.75). I would like it to be presented as a …

Jul 16, 2025 · Hi Alteryx Community, I have problem in formulating a formula considering the rule of rounding ending in 5 which says that if the digit immediately before the 5 is even, round …

‎ 08-05-2022 02:45 AM thx for the prompt response @messi007, may I ask one more question that how to make the decimal places 2 digits only? when some results came out like …

Feb 24, 2021 · 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 …

Apr 1, 2016 · Hi, I have the below table and want to round Rent Balance to two decimal places and the result should match as in the Required column. I tried using the Round function but …

Aug 21, 2025 · Hello I am cleaning a dataset and there are a few currency fields and a percent field in decimal form. I want to restrict the number of characters after the decimal to only 2. On …

Sep 2, 2020 · What formula do we use to show a round to two decimal places (for example)? I fail to understand how Round (x,mult) exactly work.

Feb 15, 2019 · However I don't want to convert all of the numbers in my Rate column to a percent. I have another column that indicates "flat rate" or "percent" and I only want to convert the …

Apr 11, 2022 · yes. that is fixed decimal. you can use a select tool on a numeric column to set it to 19.2 (for example) which should give you two decimal places.