8 Replies Latest reply: Apr 8, 2011 8:11 AM by Gerhard Laubscher RSS

    Chart with Count If Statement

    Gerhard Laubscher

      Hi,

      I have the following fields in an account extract (there is a row per customer):

      • Number of purchases for the cycle
      • Valueof purchases for the cycle
      • Number of paymentsfor the cycle
      • Value of paymentsfor the cycle

      Every customer in the database who has not yet made a purchase will have a zero value in the two purchase fields.

      I want to create a chart table that shows the number of customers who has made a purchase during the cycle.

      I'm new to QV - in excel I would use something like =CountIf("number of purchases for the cycle" <> 0)

      Please can someone help me to do this in QV, I am lost with these expressions.