Formatting a SUBTOTAL

[LeonelSanchezJr]

I need my SUBTOTALS to be formatted as INTEGERS instead of DECIMALS.

Thanks,

Leo ;-)

 

[kiddpete]

Use ON field SUBFOOT with RECAPs. Like;

SUM Realfld
BY sortfld
ON sortfld RECAP
Intfld/I5=Realfld;
ON sortfld SUBFOOT
"<Intfld>

 

[focwizard]

Leo,

SUBTOTAL fields take the same format as the fields which they total. What formats are the fields? If integer, then you should already be getting integer subtotals. If not, then what would expect to happen to the decimal portion of the field?