We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Remove Decimal

bubblyjai1982
8 - Asteroid

Hi All,

 

Anyone can please assist me - How to remove decimal without rounding the decimals.

 

For Example: 

 

Quantity            Output

1026.942           1026942

26.40727887     2640727887

53.158               53158

1750.02             175002

3430.00             3430

590                     590

344.98762          34498762

 

Thanks in advance !!

2 REPLIES 2
binuacs
21 - Polaris

@bubblyjai1982 

toNumber(ReplaceChar(toString([Quantity]),'.',''))
bubblyjai1982
8 - Asteroid

Thanks for your help !!

Labels
Top Solution Authors