2 Replies Latest reply: Nov 13, 2012 8:59 AM by Yaseen Pullissery RSS

    Counting a comparison between SUM and COUNT Expression

      Hi,
      I've the foloowing problem.

      I've a table with "Target" and "Sell" values divided by Seller and By Category

       

       

      SellerCategory

      Cat 01

      Cat 02Total
      Seller 01Sell101222

      Target151025
      Seller 02Sell5611

      Target5510

       

      I would like to add a column (or row) saing How many target has been reached.
      I found  that I could add "Target Reach" with "If (Sell>target, 1, 0)" is working for the Cats columns, but not for the Total (the one I really need)

       

      Please note that Sell  = COUNT(ContractNr), and Target = SUM(Target)

       

      Any idea?

       

       

      Thank you