Expression help

[#1]

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. 

[tresesco · Accepted solution]

Try using set analysis, like:

=NULLCOUNT({<ACTIVITY_SUB_TYPE = {'OPD'}>} SALESPARTDESC)

[Anonymous]

Can you post your qvw or the sample data for the same.

It would help us understand your issue on much better way

Regards

Nitin

[#4]

Perfect, thank you!