3 Replies Latest reply: Apr 7, 2014 6:23 AM by Sara Titmuss RSS

    Expression help

    Sara Titmuss

      Hello,

       

      I am trying to add an expression to a chart that calculates null values with a particular activity type.  I have it working with the expression below:

       

      =nullcount(SALESPARTDESC)

       

      However, I want it to calculate this only for an activity that is an OPD.  E.g:

       

      =NULLCOUNT(IF(ACTIVITY_SUB_TYPE = 'OPD', SALESPARTDESC).

       

      This also works but is still calculating the null values for all other activity sub types and not only OPD's.  It will only show if I select OPD.  (which is frustrating)

       

       

      Any advice will be greatly received.  Thank you.