4 Replies Latest reply: Mar 20, 2012 4:02 PM by ssha 324 RSS

    Selecting records within a chart

      Hi All, Hopefully this is an easy one and I am making a simple error. I am looking at Sales records and pre-selecting the date range. All works fine except I want to calculate a success rate based on a single logical field (scanned). I need to sum the sales value field for both records where this field is value = 1 and also where it is value = 0, then turn these two results into a % success rate to be displayed in a chart. My problem is that I cant see how to get the values SUM (sales value) where scanned = 0 and SUM (salesvalue) where scanned = 1. Any suggestions would be gratefully appreciated. Thanks in advance Mark