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

    Set Analysis - Sum if two fields null?

      I found this answer elsewhere:


      counts A when B is null



      counts A when B is not null



      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