I am having a problem using a DEFINE in a SUBFOOT when more than one ACROSS is used. Take a look at the example report below. When you run it as is, you notice that it properly lists the DEFINE sUBTOTAL in the SUBFOOT. However, if you UnComment the second ACROSS and rerun the report returns a zero for ST.CUSTOM_TOTAL. I am using the DEFINE because I need to grab only certain rows for my custom subtotal. Any advice or suggestions would be appreciated.
>>>>>>>>>>>>>>

 
DEFINE FILE CAR
BLANK/A1 = ' ';
CUSTOM_TOTAL/D33C=IF COUNTRY EQ 'ITALY' AND BODYTYPE EQ 'SEDAN' THEN DEALER_COST ELSE 0;
END
TABLE FILE CAR
SUM
	DEALER_COST
BY BLANK NOPRINT
BY COUNTRY AS ''
BY CAR AS ''
ACROSS BODYTYPE 
-*ACROSS SEATS
ON BLANK SUBFOOT
"Custom Total: <ST.CUSTOM_TOTAL "
END

This isn't working for you because you haven't SUMMED your CUSTOM_TOTAL field. Try putting CUSTOM_TOTAL NOPRINT after DEALER_COST and make your SUBFOOT on COUNTRY rather than on BLANK.

Sorry, I forgot to mention that I need to use the BLANK define in order to have this SubTotal showup at the end of my report, rather than on each Country subgroup. Knowing this do you have any other ideas?

Johnny,
This works. But is this what you need?

-* File JohnnyT.fex
DEFINE FILE CAR
BLANK/A1 = ' ';
CUSTOM_TOTAL/D33C=IF COUNTRY EQ 'ITALY' AND BODYTYPE EQ 'SEDAN' THEN DEALER_COST ELSE 0;
END
TABLE FILE CAR
SUM TOT.CUSTOM_TOTAL NOPRINT
SUM
	DEALER_COST
BY BLANK NOPRINT
BY COUNTRY AS ''
BY CAR AS ''
ACROSS BODYTYPE 
ACROSS SEATS
ON BLANK SUBFOOT
"Custom Total: <TOT.CUSTOM_TOTAL "
END

Danny - your example does work and it is what I am looking for. Do you know why you have to use the TOT. instead of ST. in the SubFoot and also, what does the extra SUM verb have to do with the solution? Thank you for your input!

Johnny,
The extra SUM forms a multi-set request (you can look it up in the manual: a very powerful feature of WebFocus).
The TOT prefix gives you the report total for the field. That is why I asked whether this is what you need.
BTW, are you coming to the summit? If so, we can meet there.

Thanks for the explanation, I am alrady modifying my report code. I had planned on going to the Summit this year, I've been to the last two, but my wife and I are expecting our next child in early June so I am staying behind this time. Are you coming in all the way from Israel or England to go to Summit? Thanks again for your help!

Yes. Coming from Israel. We will have a booth at the Summit showing our product to build self-service applications.

My supervisor will be at Summit, he'll be sure to stop by your booth. Have a safe trip.