we have this case in attached where in blue bar we have fidelity card those buy category x and the red one shows idelity card those don't buy category x . we would like show in table the fidelity card (their number) in red bar, but we no idea how to do it.
i try with sum({1-$} value) in data set analysis but in this way there are all fidelity card and not only the pharmacy's cards.
Hello Sarah, You want to see the value of the fidelity cards that didn't buy a product or a product category? First, you need to flag the sales on the load script, so you can see which records are showing a sale, then you will use that flag Then, you can remove the sales from the total, and you will get the missing fidelity) rangesum(SUM ( {< FLAG_SALES = {1} >} value ) , -1 * SUM ( {< FLAG_SALES = {1} >} value ))
And what about checking the field where you record the sale? I assume that there is a field that allows you to discern if there was a sale or not, if so check the value on that field, something on the line: rangesum(SUM ( value ) , (-1) * SUM ( {< sales= {">0"} >} value ))
only field that i have is where Sum(value) is null (you can see it in attached). but i don't know how identify it, because using if(sum(sales) is null(),0, sum(sales)) i don't get nothing.
i would like display only the card without sales (in attached whre sum(value) is "-")
