6 Replies Latest reply on Sep 2, 2014 8:49 PM by TKnTexas

    Calculation in Sub summary

    diamondrabbit

      Title

      Calculation in Sub summary

      Post

           Hi,

           I'm pretty sure you can't put a calculation in a sub summary, so does anyone know a way that I can work around: My problem is:

           I want to report weekly sales, with sub summaries per sales rep and grand total. This all works well but I need to include  the the profit margin (which is different on each sale). Profit margin is a calculation (profit/invoice). So while I can use summary fields to total the actual figures, I can't do that will profit margin.

           For instance the figures I can not get in my report are highlighted blue:

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
                          REP                     SALES                     COST                     PROFIT                     PROFIT MARGIN
                          Rob                     100                     50                     50                     50%
                                                100                     40                     60                     60%
                                                100                     40                     60                     60%
                          Rob Summary                     300                     130                     170                     57%
                                                                                                                   
                          Bob                     120                     60                     60                     50%
                                                80                     60                     20                     25%
                                                80                     50                     30                     38%
                          Bob Summary                     280                     170                     110                     39%
                                                                                                                   
                          GRAND TOTAL                     580                     300                     280                     48%

            Can anyone help me create this report with sub summary profit margins?

           Thanks Nicole