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:

      =SUM ({$ <CHANNEL = {'PROPERTY CHANNEL'}, len (trim (REGIONAL_CARTCPVEIC)) <1) >} PORTFOLIO)

       

       

      Can you help me?