Skip to Content

Summarizing a formula that refers to another summary field.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 23, 2018 at 01:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded