Required Complete Numbers

[Rhaldhar]

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.

[DataNath · Accepted solution]

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

[FinnCharlton · Accepted solution]

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

Fixed decimal works. Thanks.