REMOVE DECIMALS

[BRRLL99]

I have dataset which includes decimals

DATA	NUMBERS	EXPECTED-OUTPUT
A	24.000	24
B	24.000	24
C	23.150	23.15
D	0.007	0.007

[DataNath]

@BRRLL99 what data type is your NUMBERS field? I can only replicate this in Alteryx by making it a string field. Double automatically removes the unnecessary decimals:

[binuacs · Accepted solution]

@BRRLL99 If the number data types are in string then converting it into double will remove the decimals

Or if you are looking for a specific function then TrimRight() function will do the trick

TrimRight([NUMBERS],'0.')