Very sorry for the delay. I was away.
1. Ok. I Accept it. It might be trying to sum the Converted field.
2. I want to set the decimal format depending on the currency. It can be either 2 decimals or 3. In the Details band, I am using TRANSFORM(AMOUNT, gcDecimal) where gcDecimal it the format (either "9999.99" or "9999.999"). It works fine there. Only in the Group footer it's giving the **** when I try to sum it.
Thanks.