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