REMOVE DECIMALS

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

Data Investigation

Accepted answers

@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.')

All comments

@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:

@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.')

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703