4 Replies Latest reply: May 19, 2017 7:27 AM by Sunny Talwar RSS

    Doubt in expression with Null field criterion

    Rafael Souza

      Guys, good afternoon,



      I have the 2 expressions below:

      To add the output: = SUM ({$ <CHANNEL = {'PROPERTY CHANNEL'},>} PORTFOLIO)

      To sum the output where a field is null: = SUM (if (len (trim (REGIONAL_CARTCPVEIC)) <1, PORTFOLIO))



      How do I join the same expression in the 2 criteria, type:




      Can you help me?