Force .00 Decimals

Hi there,

I have a price list with prices that are round (ex. 66.00) and not uneven (66.12). When data types Fixed Decimals or Forced Decimals, Alteryx will display 66 and 66.12 instead of 66.00 and 66.12. How can I force Alteryx to display the zero decimals when the number is round?

Datasets

Tips and Tricks

Accepted answers

All comments

apathetichell

I have the same problem on fixed char/fixed delimiter not displaying extra decimals for whole numbers.

It doesn't actually matter if you are using a table tool though since in table properties you can force a number to have any number of decimal places.

Qiu

@kristinaheuer
I think Alteryx may not have such funtion.

If you really want to display it, the data needs to be convered to string type, use pad right for the missing zeros.

AkimasaKajitani

Actually we can only use ToString Function and change to field type to string.

eg:
ToString(66,2)

output:

This work will be done at the end of the reporting process.

apathetichell

@Qiu @AkimasaKajitani But we can also keep things as numbers and just add the decimals in dec. places above Row Rules in the table tool - no? Just checked and excel does recognize the table rendered decimals as numbers.

RaviP

Hi @kristinaheuer

Fixed Decimal seems to be working for me. Not sure if I understand your question correctly.

This is the input

After changing the type to Fixed Decimal, I see the decimal places

apathetichell

@RaviPcan't speak for @kristinaheuer but here's what I get on a browse of a fixed decimal:

Type

FixedDecimal

Records

Data Type Size

Ok	4	100.00%
Unique	2	50.00%
Null	0	0.00%
Not Ok	0	0.00%
Empty	0	0.00%

Value Statistics

Grouped Values

19-19.2

Max	19.2
Min	19
Lower quartile	19
Upper quartile	19.2
Average	19.1
Standard deviation	0.1154
Sum	76.4
Median	19.1
Variance	1.3333e-02

RaviP

Ah, I see what you're saying @apathetichell.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335