Hi,

I am using an xml file for the first time and everything is coming together nicely...However, some of my fields haven't been populated to show 2 decimal places when the last decimal is a zero. So when I look at the datafile, instead of:

I'm getting:
Being new to xml, I'm not sure if I could formulate a condition to add that zero on the end? It's either that or I'm thinking I may need to write a script to run against the data file before loading into my form...?

Thanks

Phree,

The easiest way to do it may be to convert the value to a currency and back to string. Some PressTalk may be required.

Assuming the following XML structure(just to give you an example):
You could use a custom data selection, and use the following expression:

=curtostr(strtocur(xmlget('/Data/Taxes/CURRENT_TAX')))

By converting 80.5 to currency, and back to string, it will automatically add the 0.

Hope this helps.

Regards,
Rapha

Rapha