>Jorge,
>
>This is the Format of this field: @Z$999,999,999 Do you see, why it shows me 123450.000000000?????
>
>>Hi, why don't you just format the field in the report with $999,999.99 or whatever fits your needs, this way it will work every time regardless of regional settings.
>>
>>>Hi everybody,
>>>
>>>I'm designing a report. I added fields in the body section, say, mortgage. I set format to currency and display blank if 0. I want it to be $123,250 (, separates thousand). Instead I have $123250.000000000 I checked my region settings, they are ok. I tried set decimal to 0 and set fixed on/off. Nothing helped. What else could it be?
>>>
>>>Thanks in advance.
Try removing the "@Z". It works for a TRANSFORM(123250,"$999,999").