Formula based on the Group Level

as described this seems like the basic usage of grouping. Simply creating a group based on each of those fields should do the trick. But Im guessing thats not what youre looking for. Can you provide a sample set of data and what you would be looking foir? It will help to understand better what youre looking for.

Basicly I am asking...how do you determine what Group Header/Footer the formula is located in (Group Header #1, Group Header #2, Group Header #3, etc).

Company 1 (Current Group would be 1)
Vendor 1 (Current Group would be 2)
Item 1 (Current Group would be 3)
Detail Line 1 (Current Group would be 4)
Detail Line 2 (Current Group would be 4)
Item 2 (Current Group would be 3)
Detail Line 1 (Current Group would be 4)
Detail Line 2 (Current Group would be 4)

This way I can create a single formula that can be placed in all 4 group header/footer sections of the report, that does the following.

If (Current Group = 1) then do....
else
If (Current Group = 2) then do....
else
If (Current Group = 3) then do....

Using your example
Group 1 is Company
Group 2 is Vendor
Group 3 is Item

For the example I am writing that I want to
count vendors when in Company Group
Sum payments when in Vendor Group
Average Cost when in item Group

For the example my table is SALES

IF GroupNumber = 1 Then Count({SALES.Vendor},{SALES.Company})
ELSE
IF GroupNumber = 2 Then Sum({SALES.Payments},{SALES.Vendor})
ELSE
IF GroupNumber = 3 Then Average({SALES.Cost},{SALES.Item})


This should work for what it sounds you would like to do.

I tried that, but GroupNumber is the number of Groups printed. There can be hundreds of vendors with hundreds of items per vendor.