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.
Have a look at the next reply of Sergey Berezniker to a comparable question : Re: Dynamic Format - VFP 8 Thread #949922 Message #949926