DC
Hi All..... struggling with a simple concept and wondered if anyone has ideas. Three columns DATE, SALES & GROSS PROFIT (GP). Data is entered daily . Easy to display results and graph except for one value... %GP = GP/Sales. If I select a random date filter - say June 2013 I see (2) sum values being GP $20000 & Sales 100000 = 20% GP for June 2013. I can insert a formula to give the %GP per row and I can display it as an AVG GP but this value is incorrect, particularly if there are losses or negative GP figures. What I really need to do is grab the (2) date filtered sum values (GP & SALES) and divide them. Can this be done?
