2 Replies Latest reply: Dec 5, 2017 4:34 AM by Daniele Caprelli RSS

    Sum a field satisfied an filter

    Daniele Caprelli

      Hi i need to count in a line chart, a field than satisfy a fiflter, esample:



          Sum({<CD_FORNITORE1={"XXX"},[FORNITORE1]={'XXX SOC'}>}NRPOD)

      , ''



      CD_FORNITORE : is a field of my TABLEA (i have  a filter in a dropdown button of that

      in my TABLEB i have a filed CD_FORNITORE1


      so i want SUM NRPOD of my CD_FORNITORE1=xxx AND FORNITORE1=xxx soc


      it must satisfy that in my TABLEB becouse in that table i need to count the NRPOD where satisty only that