Error Conversion Rate

Answered
Patricio asked on January 23, 2023

The number format is incorrect for some rows when executing the conversion rate with 2 decimals.
 
 

Attachments:
conversionrate.png

3 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster January 24, 2023

Hello, Patricio,

Thank you for reaching out to us.

The provided screenshot shows that all fields have 2 decimals after the decimal separator. Could you please specify the expected result of the formatting with 2 decimals? 

Looking forward to hearing from you.

Kind regards,
Nadia

Public
Patricio January 24, 2023

Hi! attach more images about this case.
before, format, and after

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster January 25, 2023

Hello, Patricio,

Thank you for providing the screenshots.

It seems that the formatting is applied correctly. For example, after setting the 2 decimals format on your data, it is expected to look like this:

166 600 024 701 212 -> 166 600 024 701 212.00
166.60002470121154 -> 166.60

Could you please specify which result exactly you want to achieve using the formatting? It would greatly help us. 

Looking forward to hearing from you.

Kind regards,
Nadia 

Please login or Register to Submit Answer