Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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