In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Required Complete Numbers

Rhaldhar
8 - Asteroid

Hi All,

 

Can you help me to get complete digit of FX rate. as formula box rate is coming in 9 digits however the result is coming 7 digits. I need same as coming in formula box.

 

 
 

Screenshot 2023-08-31 192449.png

3 REPLIES 3
DataNath
17 - Castor
17 - Castor

Hey @Rhaldhar, try making the data type a FixedDecimal with 19, 8 as the Precision and Scale respectively. 

FinnCharlton
13 - Pulsar

@Rhaldhar Not sure why it's doing this, Doubles are big enough for 15 decimals worth of precision. You could try setting to a fixed decimal with size 10.9

Rhaldhar
8 - Asteroid

Fixed decimal works. Thanks.

Labels
Top Solution Authors