AnsweredAssumed Answered

Calculation in Sub summary

Question asked by diamondrabbit on Aug 28, 2014
Latest reply on Sep 2, 2014 by TKnTexas

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

Outcomes