I have designed a report that shows invoicing and labour a profit type report however in the database I use you may have many invoices to one labour transaction so in the details section I have the labour repeating itself many times when I try and summarise the figure to GH2 it may add up the labour four times I can over come this problem by using a maxium or what I have done is asked to
Sum(Labour) \Count(number of invoices)
Which has given me the correct figures but I can't get the Figures for GH1 which is Customers and a grand total does anyone have any idea's ?
Sum(Labour) \Count(number of invoices)
Which has given me the correct figures but I can't get the Figures for GH1 which is Customers and a grand total does anyone have any idea's ?