8 Replies Latest reply: May 15, 2013 10:13 AM by David Koschei RSS

    Set Analysis - Sum if two fields null?

    David Koschei

      I found this answer elsewhere:

       

      counts A when B is null

      =count({$<[A]={"=isnull(B)"}>}[A])

       

      counts A when B is not null

      =count({$<[B]={"*"}>}[A])

       

      And both of these work perfectly.

       

      What I'm trying to do now is count A when both B AND C are null.


      =count({$<[A]={"=isnull(B)","=isnull(C)"}>}[A]) didn't work.

      =count({$<[A]={"=isnull(B)"},[A]={"=isnull(C)"}>}[A]) also didn't work.

       

      Anyone know the syntax? Or is this not possible?

       

      Thank you