Summarizing a formula that refers to another summary field.

[Former Member]

I have created a summarized formula in crystal reports and want to refer that to summary field. For ex: commission calculated on each invoice margin. I want to show summary for each sales person commission under sales person group. can someone help me please.

[ashrafsharaf]

Unfortunately this is not achievable using regular summary functions, so here is what i would do:

1. Create a shared variable to increment the summary you want to show

Shared numbervar I; 
I := I + {Sales Commission SUM Field}; 

2. Place it on the same level as the Sales Commission

3. Create a variable to display the total and place it in your group footer/report footer (assuming you have a Sales Employee group)

Shared numbervar I;

I;

4. Create a variable to reset the increment for each group and place it in the group footer under the total

Shared numbervar I;

I := 0;

Good Luck,

Ashraf