Select a specific Baan field @ the Group level

[Debug44]

Using Baan IVc3...Crystal Reports 10
Report is ran on data table tiitm001
I have my report grouped by "Item Group"
The selection code field is used in our system with 4 possible selections (MA, MB, MC, and MD)
I need to have the report print out the "Lead Time" by "Selection code" in the "Item Group" footer
(All MA's are the same lead times, as are the MB's, etc)

It will print the MA only and then report 0.0 for the rest when in the group footer.
I currently have the MA formula as below...
if {tiitm001.csel}like "*MA*" then {tiitm001.oltm}
I have the same for "MB" with the exception of the selection of "MB"
I have 4 seperate formulas as I need to report all of the "Selection Code" lead times for review.

What I am trying to do appears easy, yet it has me stumped...Any help would be greatly appreciated.
Thanks
Bart

 

[lbass]

Please explain the relationship between selection code and item group. Some sample detail level data would help.

-LB

 

[Debug44]

Sorry LB

I got it figured out right after I posted...
I put the formulas in the detail section and then did a summary on each. It worked fine.

Funny, I worked on this for about 6 hours to no avail and then figured it out 10 minutes after posting...
(Forest, trees I guess)

Yet thank you very much for the rapid response...