I have built a master file for a fixed format text file. I managed to get it so that it is now importing correctly. One of the fields I am importing is actually a currency amount and is 12 bytes. In order to get it to import into the correct field, I had to set this field in the master as A12. Now when I want to sum this field it doesn't recognize it as a numeric value. How can I fix this?

Lee, in the master there is actualy 2 formats. The first tells WebFOCUS how to use it and is referred to a the USAGE format. The second is tells webfocus how it is actually stored and is referred to a the ACTUAL format. It the field you are using has leading zeros and in then a format line this 000000100.00 meaning 100 dollars. You should be able to set the USAGE to D12.2.

Hope this helps