Backdrop:  Report that summarizes sales and profits for a given period of time.

Dilemma:  I have created a value box (number) in order to calculate the margin % of each item category, but cannot get it to 'find' the derived total $revenue amount and the derived total $profit field so that it can make the calculation.

Example of output of the current report:
Category             Revenue                   Profit         Margin
54                   $25,005.12            $4,691.08       ??
                                                           
                                   
54W                   $20,828.56            $9,853.11       ??
                                                           
                                   
56                   $19,088.43            $3,607.28       ??


And here is the programming in the MarginPerc value box (that returns "1" in each row ... I put the last line of programming in there to try and determine if I was reaching the intended data (which I'm not)

var vMarg as double
var vProfit as double
var vCatRevenue as double

vMarg = 0
vProfit = 0
vCatRevenue = 0

vProfit = LIProfitTotalItemCatUmb
vCatRevenue = GF_0_COL_4

MarginPerc = @TN(vCatRevenue)


If (@TN(vProfit) > 0) and (@TN(vCatRevenue) > 0)
  {
     vMarg = ((@TN(vProfit))/(@TN(vCatRevenue)))
     vMarg = 100 * @TN(vMarg)
     MarginPerc = @TN(vMarg)
  }
    else {MarginPerc = 1}

Hi Ray,

I haven't spent a lot of time learning the Report Writer (obviously), and haven't 'added a group' before.  I'll implement your instruction this weekend.

Thank you.