Calculated field return exponent value

[Former Member]

I have a calculated field that simply is dividing one field value (currency rate) by another field's value (currency ratio). If the ratio is larg (>10000) than the result is shown as an exponent value.

Example:

rate is 4.64388604805481, ratio is 100000

result (rate/ratio) is 4.64388604805481e-05

I would like to get a the result like this:

0.0000464388604805481

I cannot find a way to format it like this. Does someone have an idea?

[Former Member]

Hi Peter,

As per MDM Console, Currency fields can have only maximum of 6 decimal places..you can perform this may be outside the components like you can use some API to perform this...

hope this might helps...

thanks

Alexander