I assume youa re trying to get sums at 2 differnet grouping levels...

maybe @commision is summing at group 1 and @totalcommision is a sum for the report.

If this is the case don't bother with a formula for these but if you really want to your @commision would be

@totalcommision is Sum ({tablename.Commition}) placed on RH or RF.

 

 

Easier to just use the Summary function. Click on it, select the field to summarize (Commition), select SUM and set at group level 1. repeat and select grand total for all.

Your first formula @Revenue =  Sum ({TB.APPREV}) is going to give you a total of the apprev field for the entire report.

So your second formula @TotalRevenue = Sum ({@Revenue}) is trying to give you a Sum of the original SUM which does not really make sense?

I think you may need to start back at square one here and post some sample data and some sample of what you want to calculate from it.

I ask this because the straight formula of SUM ({TB.CAPREV}) without sub reports should already be 2900. In the above example if there are no subreports and assuming you are grouping on the employee name here the formula of SUM ({TB.CAPREV},{TB.EmployeeField}) would give you the results the 3 seperate results of 1000,700,1200.

If you used the summary function in crystal to make the sum_field and you move that around in your report from group level to group level it autmatically changes itself for grouping.

Assuming your data is more like:

Employee      Pay Rate     Revenue    Commission      Gross Cost

 

Group on Employee field.

Highlight Revenue field. Click on SUmmar Function. Set Summary to SUM at Group Footer 1.

Repeat for except set Summary at Grand total (Report Footer).

Repeat both steps but use the Commision field.

Repeat again with Gross cost field.

IN your report deisgn move the totals that were in the group 1 footer to the group 1 header.

suppress the detail section.

preview and see if that is what you wanted.

Just look into the processes here.

To help you disect your report, the formula that uses the SUM of a field returns and displays the full value of all of those fields, it is not incrementally displaying the addition of row to row. That is usually a variable or a Running Total field. Therefore a formula field that is written as "SUM(table.field)" would show you the exact same number regardless of where you place it in the report (report header, report footer, group header, detail row, whatever).