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

# 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

• ###### Selecting records within a chart

Hi,  Try SUM({<scanned = {"0","1"}>} salesvalue)    Cheers

• ###### Selecting records within a chart

Thanks for the help. I think I may have expressed myself badly in the question. i think this solution gives me a total for both possible values of scanned, i need to have two seperate totals for the SUM(salesvalue) so that I can present a % of all salesvalue that are scanned = 1.

• ###### Selecting records within a chart

Hi

Check with this

SUM({<scanned = {0}>} salesvalue) for scanned =0

SUM({<scanned = {1}>} salesvalue) for scanned =1

Celambarasan

• ###### Selecting records within a chart

Try

SUM({<scanned = {"0"}>} salesvalue)    and    SUM({<scanned = {"1"}>} salesvalue)