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

    Counting a comparison between SUM and COUNT Expression

      I've the foloowing problem.

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




      Cat 01

      Cat 02Total
      Seller 01Sell101222

      Seller 02Sell5611



      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