Force .00 Decimals

[kristinaheuer]

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?

[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

4

Data Type Size

19

	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.