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:

       

      if(GetFieldSelections(CD_FORNITORE)='XXX',

          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